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

Chapter 16. Professional Charting Techni... > Linking Chart Text to Worksheet Cell...

Linking Chart Text to Worksheet Cells

When setting up workbooks that will be used by several people, you might want to link text or numbers from a cell in the workbook to a chart, so that when the chart is shown, it's representative of the worksheet. Suppose that you have a worksheet that performs many calculations and the chart is the outcome of the calculations, but is titled differently every time a calculation is done. In this case, you'll want to see a different title for each scenario or calculation. To link a cell to a chart, just select the chart and, in the Formula bar, type the formula =cell, substituting the cell reference for cell. When text or a number is generated in the cell, it shows up on the chart as well.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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