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

--

Debra Dalgleish

Excel FAQ, Tips & Book List

http://www.yqcomputer.com/

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/

I tried your suggestion on Excel 2000. It does not work. Could you be more

specific?

Regards,

Debu

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

_______

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/

_______

1. Add label on y-axis and x-axis in excel using Report Generation toolkit

2. Chart X-axis & Y-axis Title

3. Linkaxes: odd y-axis scaling when only x-axis is linked

4. distance between y-axis label and axis

5. x-axis labelling - how to put it above the axis?

6. XY scatter plot: multiple series on x-axis; common y-axis

7. Does any Chart Y-axis with 2 Values on X-axis(A train's tracking)

8. How do I change X-Axis values in a chart with 2 Y-Axis?

9. X-Axis When Y-Axis has Plus and Minus Values.

10. Line parallel to y-axis and then parallel to the x-axis.

11. how to take off "number" in x-axis and y-axis?

12. plotting data points with numerical y-axis and a string x-axis

13. X-axis lable name & Y-axis lable name

14. Moving Y-axis to sit at 0 on X-axis

15. Secondary X-axis with reverse Y-axis

4 post • Page:**1** of **1**