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

5. Charting Hacks > 58. Link Chart Text Elements to a Cell

Link Chart Text Elements to a Cell

When creating and using charts repetitively, it can be handy to know how to link some of your chart text elements, such as titles and labels, directly to a cell. This means that if and when your underlying data changes, your chart data and its text elements will always be in harmony.

The chart text elements you can link to a cell are the chart title, the primary and secondary X-axis titles, the primary and secondary Y-axis titles, and the series data labels.

To see how this is done, you will link the title of a chart to a cell. So, to begin, set up some data such as that shown in Figure 5-38 and, using the Chart Wizard, create a basic clustered column chart. Now click cell A17 and type


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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