Microsoft® Office Excel® 2007 Plain & Simple

Customizing Chart Data

Whenever you create a chart for a business, there’s always the possibility that the data displayed in the chart will change. Whether those changes reflect continuing sales, updated values that account for returns and inventory charges, or investment projections revised to match market conditions, you can update your chart by identifying a new data source. The data can be in any workbook on your computer or network—all you need to do is identify the cells with the data, and Excel will do the rest.

Change the Source Data for Your Chart

1. Click the chart you want to change.

2. Click the Design tab.

3. Click Select Data.

4. Click in the Chart ...