Entering Chart Data


You can enter chart data in the worksheet either by typing it or by inserting it from a different source. The worksheet is designed to make data entry easy, so direct typing is best when you're entering brief, simple data. For more complex or longer data, and when you're concerned about accuracy, insert and link your data to the chart. When you first insert a chart, the worksheet contains sample labels and numbers. If you're entering data by typing, click a cell to make it the active cell, and then select the sample information and replace it with your own.

Enter Data in the Worksheet


Click the chart you want to modify, and then click the Edit Data button on the Design tab under Chart Tools.

To delete the sample data, click the upper-left heading button to select all the cells, and then press Delete.

Click the cell to make it active.

Type the data you want to enter in the cell.

Press Enter to move the insertion point down one row or press Tab to move the insertion point right to the next cell.

If necessary, select the data you want for the chart, click the Design tab, click the Resize Table button, and then click OK.

To close the worksheet and view the chart, click the Close button on the Excel worksheet and return to PowerPoint.

Did You Know?

You can turn automatic completion of cell entries on or off. Excel completes text entries that you start to type. Click the Office button, click Excel Options, click Advanced in the left pane, select or clear Enable AutoComplete for cell values check box, and then click OK.




Microsoft Office PowerPoint 2007 On Demand
Microsoft Office PowerPoint 2007 On Demand
ISBN: 0789736438
EAN: 2147483647
Year: 2006
Pages: 348

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net