Delete all labels on a line chart

S

Steve Mackay

How do I delete all labels for every point on a line chart, using
VBA? I have 11 series of data, and I want to delete all labels before
running some other code?

Thanks
Steve
 
A

Andy Pope

Hi,

Try this to remove all data labels from all series.

ActiveChart.ApplyDataLabels xlDataLabelsShowNone

Or all data labels for a specific series.

Activechart.SeriesCollection(3).hasdatalabels=false


Cheers
Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hiding 0 value data labels in chart 8
Label Position - Above & Below 1
Excel 2007 chart line width + axis labelling with VBA 6
Delete any Lables with "0%" value in pie chart 2
Stack Chart Help 1
Chart datalabels linked to cells 1
programming 33 tabs with 1 chart on each, 9 series lines per chart 1
add labels to line chart 7

Top