Pie Chart Best Fit Labels Overlapping - VBA Fix

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 m...

Charting

excel

Macros and VBA

Shozab
Jul 15, 2021
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.

https://chartexpo.com/utmAction/MTErTVRDK3hsK1NCK01TT0ZUQ01UKwo=
https://chartexpo.com/utmAction/MTErTVRDK2dzK1NCK01TT0ZUQ01UKw==

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

I hope it will be helpful for you.

All the best!

Shozab

Brass Contributor

Jul 15, 2021

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.

https://chartexpo.com/utmAction/MTErTVRDK3hsK1NCK01TT0ZUQ01UKwo=
https://chartexpo.com/utmAction/MTErTVRDK2dzK1NCK01TT0ZUQ01UKw==

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

I hope it will be helpful for you.

All the best!

CWTocci

Copper Contributor

Jul 19, 2021

Thank You!

Forum Discussion

Pie Chart Best Fit Labels Overlapping - VBA Fix

Resources