Value of the Last Data Point Only

[Ronbo]

How do I get just the data value of the last data point to display?

Thanks a lot for any help.

Regards,

 

[Debra Dalgleish]

You could adapt the code that Jon Peltier has on his web site:

http://www.peltiertech.com/Excel/Charts/LabelLastPoint.html

Omit the line that changes the label to the series name.

 

[Andy Pope]

Hi,

And here's a non vba approach.
http://www.andypope.info/charts/Labellast.htm

Cheers
Andy