Forum Discussion

CWTocci's avatar
CWTocci
Copper Contributor
Jul 15, 2021
Solved

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's avatar
    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!

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Jul 15, 2021
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.

Resources