Link Title/Subtitle/X-Axis Label/Y-Axis Label to Cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I link X or Y Axis Labels or Title of a chart to the content of a
cell. I want to do it so that whenever I update the cell, it will update the
labels or Title of the chart too.
 
Select the Title
Type an equal sign
Click on the cell that you want to link to
Press the Enter key
 
I tried your suggestion on Excel 2000. It does not work. Could you be more
specific?
Regards,
Debu
 
Select the title, but not so you get the blinking insertion point within the text of
the title: you need to have the gray selection rectangle around the title.

Now type the equals key (you'll see the equals sign in the formula bar), click on
the cell (the cell reference will appear after the equals sign in the formula bar),
and press Enter.

This works in every version of Excel since about Excel 5.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top