Delete all labels on a line chart
 

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

Delete all labels on a line chart
 

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=fals e


Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Steve Mackay" wrote in message
...
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