VBA Excel: ElementDataLabelCallout display Data

Question

I am facing a problem while coding VBA. I have created a pie chart and every Method that is available to display the Data used for the Chart is not very good looking. The only one that fits my needs is the ElementDataLabelCallout Method, but it only shows the percentage and not like for example ElementDataLabelShow the raw data. Is there a way to edit the VBA Code so that the Callout Method displays the data instead of the percentages ?

Set chrt = Sheets(Chart).ChartObjects.Add(Left:=0, Width:=540, Top:=0, Height:=420)
chrt.Chart.ChartType = xlPie
chrt.Chart.SetSourceData Source:=Sheets(Sheetname).Range("A1:B6"), PlotBy:=xlColumns
chrt.Chart.SetElement msoElementDataLabelCallout

This is how I did it but it displays only the percentage in the pie chart.

bankeris · Accepted Answer · 2021-04-14 12:03:25Z

1

Always try Macro recording it writes everything :)

chrt.Chart.FullSeriesCollection(1).DataLabels.ShowValue = True
chrt.Chart.FullSeriesCollection(1).DataLabels.ShowPercentage = False

answered Apr 14, 2021 at 12:03

bankeris

2011 silver badge10 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Actual Programmer Over a year ago

Thanks! just did that myself but yours is even better!

Actual Programmer · Accepted Answer · 2021-04-14 12:06:34Z

0

I have found the solution myself with recording a Macro its somewhat like this:

ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.FullSeriesCollection(1).DataLabels.Select
Selection.ShowPercentage = False
Selection.ShowValue = True

answered Apr 14, 2021 at 12:06

Actual Programmer

31 bronze badge

Collectives™ on Stack Overflow

VBA Excel: ElementDataLabelCallout display Data

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related