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