Advertisement
Guest User

Untitled

a guest
May 20th, 2019
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.41 KB | None | 0 0
  1. Sub datalabels()
  2.  
  3. For Each myChart In ActiveSheet.ChartObjects
  4. For Each mySrs In myChart.chart.SeriesCollection
  5. With mySrs
  6. If Not .HasDataLabels Then
  7. .ApplyDataLabels
  8. End If
  9.  
  10. .datalabels.ShowSeriesName = True
  11. .datalabels.ShowValue = False
  12.  
  13. End With
  14. Next mySrs
  15. Next myChart
  16.  
  17. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement