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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Steve Mackay" <(E-Mail Removed)> wrote in message
news:19f1c0a9-482f-40aa-9708-(E-Mail Removed)...
> 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