Data series labels
 

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.

Data series labels
 

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 wrote:
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, Microsoft MVP - Excel
http://www.andypope.info

Data series labels
 

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" wrote:

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 wrote:
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, Microsoft MVP - Excel
http://www.andypope.info

Data series labels
 

Hi,

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

Maybe you need to re consider the chart type.

Cheers
Andy

cpt7750 wrote:
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" wrote:


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 wrote:

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, Microsoft MVP - Excel
http://www.andypope.info


--

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