After you create a chart in a presentation, you can edit
the chart data in the Data Table window. The
window is not available when you create a chart based on a table in
documents or based on a sheet.
When you create a chart that is based on default data, or
when you copy a chart into your document or presentation, you can
open the Data Table window to enter your own
data. The chart responds to the data in a live preview. Some changes
become visible only after you close and reopen the Data
Table window.
- Double-click the chart to enter the editing mode.
- Right-click and select Chart Data.
The Data Table window opens. You can also click
on the toolbar. The data series are organized
in columns. The role of the left most column is set to categories
or data labels respectively. The contents of the left most column
are always formatted as text. You can insert more categories to be
used as hierarchical labels.
- Click a cell in the window and change the contents. Click
another cell to see the changed contents in the preview.
- Enter the name of the data series in the text box above
the column.
- Use the buttons above the table to insert or delete rows
and columns. For data series with multiple columns, only whole data
series can be inserted or deleted.
- The order of the data series in the chart is the same as
in the data table. Use the Move Series Right button
to switch the current column with its neighbor on the right.
- The order of the categories or data points in the chart
is the same as in the data table. Use the Move Row Down button
to switch the current row with its neighbor below.
- Close the Chart Data window to apply
all changes to the chart. Click to cancel the changes.