The formula has to go into the worksheet. If the data is contiguous (no
blanks) and starts in B2 and may extend downward an indeterminate number of
rows, put this formula into B1:

=OFFSET(B1,COUNTA(B2:B10000))

Then use cell B1 as the name of the series.

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
Advanced Excel Conference - Training in Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______


"Zukoski" wrote in message
...
I want the latest value in my chart to be in the legend. Currently, I have
to
manually update it each month in the "Name" section of the series.Can I
type
in a formula to display the latest value from the sheet?