Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Dim MyChart As Chart
- Dim ChartPoints As Points
- Dim ChartDataLables As DataLabel
- 'Dim NumberOfSeries As Series
- Set MyChart = ActiveSheet.ChartObjects("Chart 1").Chart
- 'Set NumberOfSeries = MyChart.SeriesCollection.Count
- Set ChartPoints = MyChart.SeriesCollection(1).Points
- ChartPoints(ChartPoints.Count).ApplyDataLabels
- Set ChartDataLables = ChartPoints(ChartPoints.Count).DataLabel
- 'For Each NumberOfSeries In MyChart
- With MyChart
- With ChartDataLables
- .Position = xlLabelPositionRight
- .HorizontalAlignment = xlCenter
- .Font.Size = 8
- .NumberFormat = "0.00"
- .ShowSeriesName = True
- .Font.Name = "Arial Narrow"
- End With
- End With
- 'Next NumberOfSeries
- End Sub
Add Comment
Please, Sign In to add comment