CHAPTER 24 IN DEPTH: CALC Sorting Data (Domain and web hosting)
CHAPTER 24 IN DEPTH: CALC Sorting Data Within a spreadsheet, you may want to sort data according to any number of criteria. For example, you might want to show a list of numbers from highest to lowest, or rearrange a list of names so that they re in alphabetical order. This is easy to do within Calc. Start by highlighting the range of data you wish to sort. Alternatively, you can simply select one cell within it, because Calc is usually able to figure out the range of cells you want to use. Then select Data . Sort from the main menu. Calc will automatically select a sort key, which will appear in the Sort By drop-down list, as shown in Figure 24-3. However, you can also choose your own sort key from the drop-down menu if you wish, and you can choose to further refine your selection by choosing up to two more sort subkeys from the other drop-down menus. Figure 24-3. Data can be sorted so that it s in alphabetical or numerical order. Creating Charts Charts are useful because they present a quick visual summary of data. Calc produces charts through a step-by-step wizard, so it becomes very easy indeed. Here are the steps: 1. Highlight the data you want to graph. Be careful to include only the data itself and not any surrounding cells, or even the cell that contains the title for the array of data. 2. Select the Insert . Chart menu option, or click the Insert Chart button on the Standard toolbar.