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

D

Debu

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.
 
D

Debra Dalgleish

Select the Title
Type an equal sign
Click on the cell that you want to link to
Press the Enter key
 
D

Debu

I tried your suggestion on Excel 2000. It does not work. Could you be more
specific?
Regards,
Debu
 
J

Jon Peltier

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/
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top