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

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

Post by RGVid » Sat, 20 Nov 2004 07:09:08


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.
 
 
 

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

Post by Debra Dalg » Sat, 20 Nov 2004 10:01:54

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




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.yqcomputer.com/

 
 
 

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

Post by RGVid » Fri, 26 Nov 2004 06:51:04

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

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

Post by Jon Peltie » Fri, 26 Nov 2004 14:49:00

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://www.yqcomputer.com/
_______