Posted elsewhere but no solution has been provided so trying here!

I have a number of pie charts that are created dynamically but I have a problem of some of them have overlapping labels as they need to be outside each slice.

Where this is the case I am going to convert them to a Bar of Pie which effectively solves the problem but at the moment the user has to go through each sheet (many) and check each pie chart (some sheets have 2-3 pie charts) and then manually change where there is an overlap.

So what I need to do is utilise some code to detect if there are any label overlaps and I found the following on http://stackoverflow.com/questions/8...-in-line-chart
Please Login or Register  to view this content.
With the following, rather than moving the lable I would simply add a line of code to change the pie chart to a Bar of Pie chart if an overlap is detected. 
Please Login or Register  to view this content.
I have tested the above but it is built for multi series line charts and in all honesty I am struggling to adapt it to deal with pie charts so if anyone has some experience with this or could interpret the code to allow me to amend it would be greatly appreciated.

I don't have any other options available to fix this so removing labels less than x%, etc isn't possible and also I don't want to have to add controls/code to look at the the many sheets to deal with the many more pie chart due to the time it would take to modify the code for each chart.


TIA