Microsoft Office Tutorials and References
In Depth Information
Change the Chart Data
EXCEL
chapter 12
Change the
Chart Data
Working with Charts
Whenever you change data referenced in your chart,
Excel automatically updates the chart data. If you are
dealing with a large spreadsheet, however, locating the
data you need to change can be difficult. Fortunately,
Excel includes a special tool to help you do just that.
Change the Chart Data
1 Select the chart that you want to
edit.
2 Click the Design tab on the
Ribbon.
3 Click the Select Data button.
2
3
1
Excel highlights the source data in
the worksheet with a dashed
border and displays the Select
Data Source dialog box.
4 Edit the data range here, or click
and drag the corner handle of the
source range to add or subtract
cells.
4
You can edit the series or axis
labels using these options.
5 Click OK.
5
Excel updates the chart.
215
 
Search JabSto ::




Custom Search