Thread: Delete all labels on a line chart
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Andy Pope Andy Pope is offline
external usenet poster
  
Posts: 2,489
Default 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

Reply With QuoteReply With Quote