Microsoft® Excel® 2010 Inside Out

Modifying the Data Source for Your Chart

The simplest way to add new data points to an existing series on a chart is to make the chart’s source range a table (select any cell within the range, and press Ctrl+T; for more information, see Chapter 22) and then add new rows to the table. Excel 2010 incorporates these rows into the chart without requiring you to do anything further.

If you add a new column immediately to the right of a table, Excel expands the table to include the column. If you’ve created a chart from such a table, the new column becomes a new data series. That might or might not be desirable, depending on the contents of the new column. If you find yourself with an unwanted new series, you can delete it with the help of the Select ...