Archive of Mr Excel Message Board

Check out Bill's new book on Charts and Graphs for Microsoft Office Excel 2007

Back to Charting for Excel archive index
Back to archive home

Chart Labels & Cell References

Posted by Ken Brading on January 19, 2000 12:54 PM
I would like to include the contents of a cell in a
chart label with some text. What special characters
(if any) do I use for the chart to interpret
Page!$A$1 as a cell reference instead of text?

Ken


Re: Chart Labels & Cell References

Posted by kaiowas on January 20, 2000 5:58 AM

For some unknown reason excel will only let you put EITHER normal text OR a cell reference into a chart label, mixing two would require a formula which it won't let you do.

Anyway the solution is to put a formula in a spare cell, the result of which is the exact text you want in your chart label eg.

="Profits for Year " & A1

then on your chart select the label and instead of typing direct into the box click on the formula bar at the top of the page and then type a reference to the cell containing the earlier formula eg.

=Sheet1!A2

Your label should now contain "Profits for Year 1999" (assuming of course that cell A1 contained the value "1999")


Re: Chart Labels & Cell References

Posted by Ken Brading on January 20, 2000 7:26 AM

Kaiowas,
Thank you very much.
Ken


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.