Jul 15 2021 05:49 AM
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.
Jul 15 2021 06:44 AM
Jul 15 2021 06:58 AM
SolutionHi @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.
I hope it will be helpful for you.
All the best!
Jul 19 2021 05:35 AM - edited Jul 19 2021 06:35 AM
Thank You!
Jul 15 2021 06:58 AM
SolutionHi @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.
I hope it will be helpful for you.
All the best!