Microsoft Office Tutorials and References
In Depth Information
Changing a chart’s data source
Changing a chart’s data source
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 does the rest.
Change the source data for your chart
1 Click the chart that you want to change.
2 Click the Design tab.
3 Click Select Data.
4 Click in the Chart Data Range field.
5 Select the cells that you want to provide the new source data.
Click OK.
Search JabSto ::

Custom Search