- Introduction
- Creating SmartArt Graphics
- Using the Text Pane with SmartArt Graphics
- Modifying a SmartArt Graphic
- Resizing a SmartArt Graphic
- Formatting a SmartArt Graphic
- Formatting a Shape in a SmartArt Graphic
- Creating an Organization Chart
- Modifying an Organization Chart
- Inserting a Chart
- Selecting Chart Data
- Entering Chart Data
- Editing Chart Data
- Importing Data
- Modifying the Data Worksheet
- Selecting a Chart Type, Layout, and Style
- Formatting Chart Objects
- Changing the Chart Layout Objects
- Saving a Chart Template
- Inserting a Table
- Modifying a Table
- Formatting a Table
- Adding a Quick Style to a Table
- Applying Effects to a Table
- Sharing Information Among Documents
- Embedding and Linking an Object
- Modifying Links
- Inserting a Microsoft Excel Chart
- Inserting a Microsoft Word Document
- Inserting a Microsoft Organization Chart
- Modifying a Microsoft Organization Chart
- Linking and Embedding Sounds
This chapter is from the book
This chapter is from the book
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
)
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.