Microsoft Office Tutorials and References
In Depth Information
Editing and Revising Chart Data
Figure 4-26
Final line chart
horizontal and
vertical gridlines
vertical axis title
Editing and Revising Chart Data
Chart data can be edited and revised at any time. You do this by modifying the data
range that the chart is based on, not by directly modifying the data in the chart. The
change can be as simple as updating a specifi c value within the data source. Or it can be
as involved as adding another data series to the chart.
Changing a Data Value
Charts remain linked or connected to their data sources, even if they appear in different
worksheets. If you change any values or labels in the data source, the chart is
automatically updated to show the new content. One advantage of Excel charts is that you can
quickly see how changing one or more values affects a graph.
Ajita found a data entry error in the Assets worksheet—the amount of assets in the
Other category entered in cell B8 should be $8,360, not $3,360. She also wants the
label “Other” to be changed to “Other Assets.” This change also needs to be refl ected in
the Allocation of Assets pie chart you created based on this data. Because both the asset
values and the asset labels are linked to the pie chart, when you make these changes in
the Assets worksheet, they will automatically be refl ected in the pie chart.
To edit the data source for the assets pie chart:
1. Go to the Assets worksheet.
2. In cell A8, edit the text to Other Assets .
3. In cell B8, change the value to 8360 .
4. Go to the Summary Report worksheet, and then verify that the pie chart was
updated with the new data value and category name. Note that the percentage
values for each category were recalculated based on the new data. As a result, the
Other Assets slice increased in size to reflect its larger percentage of the whole,
and the remaining slices decreased in size. See Figure 4-27.
Search JabSto ::




Custom Search