Data series labels

[cpt7750]

How do I show only the last data label for each series in a chart and allow
them to update as new data is added to each series?
I will try to use VBA if this is the only way possible.

 

[Andy Pope]

Hi,

Depending on your chart and data VBA may not be required.
http://www.andypope.info/charts/Labellast.htm

Or Jon Peltier has some code.
http://peltiertech.com/Excel/Charts/LabelLastPoint.html

Cheers
Andy

 

[cpt7750]

Thank you Andy. This seems like a neat way to accomplish what I asked. Any
way, I will check it out.

As my chart has 30+ series and is not static (# of series may change daily),
I may end up doing it in VBA.

Charles

 

[Andy Pope]

Hi,

30+ series, really? That's got look like a plate of spaghetti

Maybe you need to re consider the chart type.

Cheers
Andy