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