Jon Peltier's has a page on the very subject!

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

NYBoy wrote:

Thanks Andy, It works!!

One more question.
It would be the last point. Every month I update the data and the line
extends and new data is entered. I always want to see the value of last
point. Would it work?


---
Message posted from http://www.ExcelForum.com/


--

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