Using the Chart Data Editor

When you create a new chart in Keynote, the Chart Data Editor is filled by default with two rows and four columns of sample data. Chances are this won't be the data that you want, so the first thing you'll need to do is get rid of the sample data so that you don't accidentally mistake it for your own data. Next, you'll need to change the row and column labels so that they match your chart's data. After that, you can enter your data in the Chart Data Editor's spreadsheet cells .

Once your data is in place, you can rearrange it by dragging rows or columns around on the spreadsheet, or you can see more of your data on-screen by resizing the spreadsheet's column width.

To delete all data in the Chart Data Editor

1.	Click and drag over the sample data in the Chart Data Editor to highlight it ( Figure 8.9 ). Figure 8.9. You'll need to highlight the sample data in the Chart Data Editor before you can delete it.
2.	Choose Edit > Delete. The values in the selected cells are replaced by zeros. You can't clear the cells entirely; the best you can do is put zero values in the cells.

Tip

• Oddly, pressing the Delete or Del key in step 2 does nothing; you must choose Delete from the Edit menu. Similarly, you cannot use the contextual menu to delete the contents of the cells.

To change row or column labels

1.	In the Chart Data Editor, double-click the name of the row or column that you want to change. The name is highlighted ( Figure 8.10 ). Figure 8.10. First you highlight one of the labels in the Chart Data Editor (left), and then you type in the new label (right).
2.	Type the new name. The new name replaces the old.
3.	Click outside the label to accept the change.

To enter data in the Chart Data Editor

1.

Click a cell in the Chart Data Editor, then type.

2.

Press the Tab key to complete the entry and move the selection to the right.

See Table 8.2 for more ways to enter data and move the selection in the Chart Data Editor.

Table 8.2. Chart Data Entry Shortcuts

K EY	W HAT IT DOES
Tab	Completes a cell entry and moves the selection to the right
Shift-Tab	Completes a cell entry and moves the selection to the left
Return	Completes a cell entry and moves the selection down
Shift-Return	Completes a cell entry and moves the selection up
Enter	Completes a cell entry and selects the cell contents
Home	Moves the selection to the beginning of the row
End	Moves the selection to the last non-blank cell in the current row

3.

(Optional) If you need another row or another column, click the Add Row or Add Column button in the Chart Data Editor.

or

Select a row or column, then Control-click (or right-click if you have a multiple-button mouse) to bring up the contextual menu, then choose Add Row Above, Add Row at Bottom, Add Column Before, or Add Column at Right ( Figure 8.11 ).

Figure 8.11. The contextual menu is often faster to use than the Format menu or the Chart Inspector.

Tip

• You can also copy and paste data from a spreadsheet application, such as Micro soft Excel or AppleWorks, into the Chart Data Editor.

To move rows or columns

1.	In the Chart Data Editor, click and drag one of the row or column labels ( Figure 8.12 ). Figure 8.12. Here, I'm dragging the East Bay line above the San Francisco line.
2.	When the row or column is where you want it, release the mouse button. The row or column moves.

To resize columns in the Chart Data Editor

1.	Position the mouse pointer over the boundary between two of the column labels. The cursor will change into a double-headed arrow.
2.	Click and drag right or left to increase or decrease the column's width.

To delete a row or column

1.	Click a row or column label to select an entire row or column.
2.	Choose Edit > Delete. or Select a row or column label, then press Delete. or Move the mouse pointer over the selected data, then Control-click (or right-click if you have a multiple-button mouse) to bring up the contextual menu, then choose Delete Row or Delete Column. The row or column disappears.