Dynamic Title on Chart

[Doug Akers]

I would like to have the title of a chart change based on
a specific cell on the spreadsheet. Any suggestions?

 

[Frank Kabel]

I would like to have the title of a chart change based on
a specific cell on the spreadsheet. Any suggestions?

Hi Doug
- click in the title field of your chart
- enter =cell_reference

also have a look at:
http://www.tushar-mehta.com/excel/newsgroups/dynamic_chart_title/index.
html

Frank

 

[Jon Peltier]

Even easier than typing the cell reference:

Select the chart title
Type =
Select the cell with the mouse

Also works with axis titles and data labels.

- Jon