How do I display latest value in chart in the legend w formula?

[Zukoski]

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?

 

[Jon Peltier]

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-06-ACNJ/AdvExcelConf200906ACNJ.html
_______