Home > Articles > Programming > General Programming/Other Languages

This chapter is from the book

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

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

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

3.gif Click the cell to make it active.

4.gif Type the data you want to enter in the cell.

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

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

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

  • + Share This
  • 🔖 Save To Your Account