Adding new data to a chart

If you add cells to the spreadsheet cell range on which you based your chart, and you want the chart to reflect the additions, you can change the cell range on which the chart is based.

To change the data plotted in a chart:
1 Select the chart, then choose Chart Options from the Edit menu.
Tip: You can also double-click the chart.
2 Click General.
3 Type the new cell range.
Enter the top-left cell address, two periods, and the bottom-right cell address (for example, A1..G10).

Related topics

  Working with the chart data
Making a chart
Formatting the chart data
About spreadsheets

 
Table of contents Index