View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default can chart title be linked to variable cell address?

It would be easier to link to one cell, and update that cell formulaically,
or paste the new values into the same range used by the chart..

To link a chart text element to a cell, select the text element so its gray
border appears, type = in the formula bar, and click on the cell.

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


"dmhittner" wrote in message
...
I have several sets of similar data for different species of birds. I would
like to be able to associate a new chart title for each new data set
(range)
entered. Can this be done in excel?

Thus i could easily switch from data set to data set, just by putting in
the
ranges and the chart title would change automatically.