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

Chapter 23. 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 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 the different title in the chart for each scenario or calculation done on the spreadsheet. To link a cell to a chart, just select the chart and type the formula =cell, substituting the cell reference for cell. A text box shows up in the chart displaying the value of the referenced cell. The text box can be formatted like any other text box. When text or a number is generated in the cell, it shows up in the text box 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