| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to change position of chart labels on line chart | Charts and Charting in Excel | |||
| labels in line chart | Charts and Charting in Excel | |||
| add labels to line chart | Excel Programming | |||
| Min, Max Value Labels in Line Chart | Charts and Charting in Excel | |||
| Sub-Categories for X-axis labels, line on bar chart? | Charts and Charting in Excel | |||
Linear Mode
