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
Click the chart you want to change.
Click the Design tab.
Click Select Data.
Click in the Chart Data Range field.
Select the cells you want to provide the new source data.
Click OK.
Add a New Series
Click the chart you want to change.
Click the Design tab.
Click Select Data.
Click Add.
Type the name you want to assign to the series.
Click in the Series Values field.
Select the cells you want to add.
Click OK to close the Edit Series dialog box.
Click OK to close the Select Data Source dialog box.
Tip
You can also type the address of the cell that contains the series name you want to use in the chart.