Entering Data in the Datasheet
The default datasheet that opens when you first create a chart includes four columns and three rows. This is a common chart format—comparing specific categories over periods of time—but only one of the hundreds of possible formats. Figure 9.13 illustrates this datasheet.
Figure 9.13. Enter chart data in a datasheet, similar to an Excel worksheet.
Note
If the data you need is already in an Excel spreadsheet, you can import directly from Excel without re-entering this information in the datasheet. To do so, choose Edit, Import File from within Microsoft Graph to open the Import File dialog box. Choose the Excel file you want to import and click Open. The Import Data Options dialog box guides you through this process. Note that you can import from Lotus 1-2-3 and text file formats as well.
The first row and first column of a datasheet serve as headers for the information in the datasheet. Therefore, the second row begins with the number 1 and the second column with the letter A. In this example, the columns display as the category axis, the rows display as the data series listed in the legend, and the cell data (A1:D3) represents the value axis.
Tip
To reverse the chart and use the column data as the data series instead of the row data, choose Data, Series in Columns. Microsoft Graph redesigns the chart based on this change. For example, if you changed the default chart to display as in columns, the quarters would appear in the legend and the locations in the category axis.
To modify the default data, you can simply overwrite the existing information in each cell.
Does your chart have extra spaces?
See the Troubleshooting section at the end of the chapter.
Inserting and Deleting Datasheet Rows and Columns
To delete a row or column, place the cursor within the appropriate row or column and choose Edit, Delete from the menu. To remove the contents of a cell rather than the cell itself, choose Edit, Clear, Contents. Clearing the contents is best when you want to remove existing data and replace it with new data. If you no longer need the row or column, you should delete it.
Tip
You can also delete a row or column by selecting its heading and pressing the Delete key.
Tip
You can also cut (Ctrl+X), copy (Ctrl+C), and paste (Ctrl+V) data in the datasheet by using keyboard commands or by choosing the toolbar buttons.
To insert a new row, select the row below where you want to place the new row and choose Insert, Cells from the menu. Microsoft Graph inserts a new row directly above the selected row.
To insert a new column, select the column heading to the right of where you want to place the new column and choose Insert, Cells. Microsoft Graph inserts a new column directly to the left of the selected column.
If you want to insert a new cell, rather than a complete row or column, select the cell adjacent to where you want to insert; choose Insert, Cells; and choose either Shift Cells Right or Shift Cells Down in the Insert dialog box (see Figure 9.14).
Figure 9.14. Determine the direction to move the existing cells in the Insert dialog box.
PowerPoint inserts a new cell and shifts the row to the right or shifts the column down, depending on your selection.
You can undo insertions and deletions by clicking the Undo button or pressing Ctrl+Z. Formatting Datasheet Column Width
To format the datasheet's column width, follow these steps:
Select the column heading of the column whose width you want to adjust.
Choose Format, Column Width. Figure 9.15 shows the Column Width dialog box, which displays.
Enter the number of spaces you want to include in the Column Width field. To adjust to the standard width, select the Use Standard Width check box.
Click the Best Fit button to have the columns adjust automatically based on the existing data.
Formatting Datasheet Numbers
You can format the text and numbers in your datasheet if you want. To format numerical data, select the cell or cells you want to format and choose Format, Number. The Format Number dialog box displays, as shown in Figure 9.16.
Figure 9.16. Customize the way numbers display in this dialog box.
Select the type of number you want from the Category list, such as date, time, or currency format. Based on your category selection, the right side of the dialog box offers additional formatting options related to the category.
For example, if you choose Currency, the right side of the dialog box lets you choose the currency symbol such as the dollar, pound, or yen. Several of the numeric categories also let you choose the number of decimal places you want to include.
Click OK to accept the formatting changes and to update your chart.
Do your datasheet numbers display in an exponential format?
See the Troubleshooting section at the end of the chapter.
Including and Excluding Rows and Columns
You can include rows and columns in your datasheet, but temporarily hide them in your presentation. To do that, select the column or row that you want to hide, and choose Data, Exclude Row/Column. The row or column appears shaded in your datasheet and temporarily disappears from your presentation. Figure 9.17 shows an example of a hidden column in a datasheet.
To include this information again, choose Data, Include Row/Col.
Tip
You can also double-click the row or column head to include or exclude the rows. In this case, the action serves as a toggle.
Returning to the Presentation from the Datasheet
When you finish formatting and modifying the datasheet, you can close it and return to the presentation itself by clicking the View Datasheet button on the toolbar. Or, you can return to working on the presentation while the datasheet remains open by clicking on any section of the presentation.