␡
- 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
This chapter is from the book
Selecting Chart Data
Use Microsoft Excel worksheet to edit your data. Select the data first in the worksheet. If you click a cell to select it, anything you type replaces the contents of the cell. If you double-click the cell, however, anything you type is inserted at the location of the cursor. You can select one cell at a time, or you can manipulate blocks of adjacent data called ranges. For example, the sample data below is a range.
Select 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.
Use one of the following to select a cell, row, column, or datasheet.
- To select a cell, click it.
- To select an entire row or column, click the row heading or column heading button.
- To select a range of cells, drag the pointer over the cells you want to select, or click the upper-left cell of the range, press and hold Shift, and then click the lower-right cell. When you select a range of cells, the active cell is white, and all other selected cells are outlined in black.
To close the worksheet and view the chart, click the Close button on the Excel worksheet and return to PowerPoint.