typo

[Charles Eaves]

I am using Excel 2007.
I have a title (with a date in it) in my worksheet and it is the same on a
graph.
For my report, I always change that date on the worksheet.
how do I automatically change the title in the graph the same time I change
a title somewhere on the worksheet.
Basically, how do i link the 2 together.
Sorry for the typo.

 

[Jon Peltier]

Construct the chart title text you want in a worksheet cell, using number
formats and/or concatenation.
Select the chart title, type an equals sign into the formula bar, then click
on the cell. Excel builds a formula like =Sheet1!$A$1 that links the title
to the cell.

Here's more about that technique:
http://peltiertech.com/WordPress/link-chart-text-to-a-cell/

- Jon

 

[Charles Eaves]

Thanks Jon for the excellent advice.
Your website is full of great info!!!!
Thanks again