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.