Delete all labels on a line chart

  • Thread starter Thread starter Steve Mackay
  • Start date Start date
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
 
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
 
Back
Top