SOLVED

Pie Chart Best Fit Labels Overlapping - VBA Fix

Copper Contributor

Morning Forums,

I am looking for a VBA that can automatically adjust the positions of the best fit data labels such that they are not overlapping on a pie chart. Right now, I have to adjust them manually and it's a real pain. Sometimes they all move around when I move one, or the leader lines will disappear... just a lot of annoyances.

The bigger issue is that I have 30 data points which is why the chart is so crowded. So, if there is a VBA that was able to check and delete the 0s (blanks) that would be even better. Then the graph likely wouldn't have overlaps.

3 Replies
The best advice I can give is not to use a pie-chart to begin with. Especially not if you have so many data points.
best response confirmed by allyreckerman (Microsoft)
Solution

Hi @CWTocci 

 

I hope you are doing well.

I created attached Pie chart in Excel with 31 points and all labels are readable and perfectly placed.

It is created from few clicks without VBA using data visualization tool in Excel.

Data Visualization Tool For Excel
Data Visualization Tool For Google Sheets

 

It has auto cluttering effect to adjust according to your data size.

Pie Chart.jpg

 

I hope it will be helpful for you.

All the best!

Thank You!

1 best response

Accepted Solutions
best response confirmed by allyreckerman (Microsoft)
Solution

Hi @CWTocci 

 

I hope you are doing well.

I created attached Pie chart in Excel with 31 points and all labels are readable and perfectly placed.

It is created from few clicks without VBA using data visualization tool in Excel.

Data Visualization Tool For Excel
Data Visualization Tool For Google Sheets

 

It has auto cluttering effect to adjust according to your data size.

Pie Chart.jpg

 

I hope it will be helpful for you.

All the best!

View solution in original post