Dynamic Titles

[Jeff]

Is there a way to make the title of a graph dynamic? I
want the title to change based on the data the chart is
presenting. In other words the data (y - values) are
dynamic, how do I make the title of the graph likewise?

I appreciate any help in this matter.

 

[Jon Peltier]

Jeff -

You can make a cell dynamic based on any criteria you want. Then link
the title to the cell. Select the title, press the Equals key, then
click on the cell.

This works with the chart title, axis titles, text boxes, and data
labels. Not with axis tick labels, that's asking too much.

- Jon