You will need to add the formatting to the macro. Use the macro recorder
whilst resetting the information to get the code required.

I have added a page to my site that shows how to label the last point
using dummy data series. This maybe more appropriate if you have dynamic
charts.
http://www.andypope.info/charts/Labellast.htm

Cheers
Andy

NYBoy wrote:

Andy, It worked great. I copied your new code and pasted and run the
macro again....

But, still my goal is not to touch the chart at all. Can we also set so
that the marco would run automatically.....
If there is no other way, then I can live with whatever I have so
far...

but another thing is, everytime I run the marcos, text size, color,
etc... changes. Is there a permanent fix?


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


--

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