• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 8. Creating Charts > Worksheet & Chart Links

Worksheet & Chart Links

When you create a chart based on worksheet data, the worksheet and chart are linked. Excel knows exactly which worksheet and cells it should look at to plot the chart. If the contents of one of those cells changes, the chart changes accordingly (Figures 20 and 21).

Figure 20. A linked worksheet and chart before (top) and after (bottom) a change to a cell's contents. When you change one, the other changes automatically.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint