Adding More Data to an Existing Chart
You can add data from individual cells that are adjacent or nonadjacent to those
already referred to by your chart, include an entire new row or column, or add data
from multiple tables.
Here are ways to add more data to a chart:
To add data from cells that are adjacent to cells already plotted, select the chart and
m
then hold down the Shift key as you click the cells you want.
140
Chapter 7
Creating Charts from Data
Chapter 7
Creating Charts from Data
141
To add data from cells that aren’t adjacent to cells already plotted, select the chart and
m
then hold down the Command key as you click or drag the cells you want.
To extend the range of adjacent cells whose values are plotted, select the chart. In the
m
table, drag the circular control in the lower right of the range to the right or down.
If the chart is a scatter chart, dragging lets you add only an even number of rows
or columns.
To add a new row or column of data, select the table and insert the row or column
m
between cells that are already plotted. When you add data to the new cells, the data
will be plotted in the chart.
To add data from cells in a different table, select the cells with data you want to add,
m
and then drag them to the chart.
The new data is added as a new data series. To view or change the chart’s source data,
click a data series in the chart to see its table and cells of origin.
To include data from hidden rows and columns in your chart, see “Including Hidden
Table Data in a Chart” on page 141.