For dynamic range charts, visit Jon Peltier's website.

For adding controlled text to a chart...

Put "fred" in cell A1
highlight your chart
in the formula bar towards the top of your screen, type =
then highlight cell A1 and press return
the word fred appears on your chart
go to A1, change to "pat"
pat appears on your chart.

You can put calculated fields on in exactly the same way.


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=529924