Value of the Last Data Point Only
 

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

Thanks a lot for any help.

Regards,

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

http://www.peltiertech.com/Excel/Cha...LastPoint.html

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

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

Thanks a lot for any help.

Regards,


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Hi,

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

Cheers
Andy

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

Thanks a lot for any help.

Regards,

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info