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
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")
Posted by Ken Brading on January 20, 2000 7:26 AM
Kaiowas,
Thank you very much.
Ken
