can variable be used in chart title

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a chart that uses input from several departments. I would like to have
the chart title change depending on the data used.
using excel 2002 sp3
 
You can write formulas is a cell which construct the text you want to appear
in the title of the chart. Select the chart title, type equals in the
formula bar, then click on the cell containing this title text. The title is
now linked to the contents of the cell, and will update when the cell
contents do.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top