Microsoft Office Tutorials and References
In Depth Information
Edit Chart Data
CHAPTER
5
Working with Layouts
6 Click the Chart Tools
Design tab.
7 Click Edit Data .
The data spreadsheet
appears.
8 Double-click a cell to edit
the data.
7
This example is editing
Cell A6.
9 Type a column heading and
data in Column E.
0 Type a row label and data in
Row 7.
Note: The colored borders around
the table adjust automatically.
A The chart updates with a new
series for the added column.
B The chart updates with a new
category for the added row.
TIP
Are there other ways to show chart data?
Yes. Switching the categories and series gives the data a
different, revealing perspective. Follow these steps:
1 Click the Chart Tools Design tab, then click Select Data.
2 Click Switch Row/Column .
3 Click OK.
97
Search JabSto ::




Custom Search