dynamic chart title

[Scholar]

Hi,

I have a daily sales chart that I update everyday. Is there a way for it update part of the title from say "As of Feb 24th" to say "As of Feb 25th" dynamically or by updating one cell in my spreadsheet?

Thank you for all your help

 

[CWatts]

Yep!

Once your chart is created, click on the title text, you'll get the dotted line around it.

Click on the dotted line so it turns solid.

Go to the formula bar where you edit a formula and put: =Sheet1!$G$1

(or whatever you want)

Push enter and all set. Just edit the value in G1

 

[Scholar]

thank you - this is exactly what i needed!