Hi,

Here are a couple of examples.

http://peltiertech.com/Excel/Charts/LabelLastPoint.html
http://www.andypope.info/charts/Labellast.htm

Cheers
Andy

assaf wrote:
I would lie to show the value of only the last point of all series in a line
chart in excel.
I can do it manually, (click the point in the graph - data labels - show
value).
Is it possible to do it automatically, so when I change the data source, the
chart will still show the value of the last point ?

--

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