ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Pie chart slices too thin (https://www.excelbanter.com/excel-programming/363511-pie-chart-slices-too-thin.html)

Fred Smith

Pie chart slices too thin
 
For a pie chart that we habitually use, I sometimes get data like 96%/1%/1%/1%.
In this case the text labels of the thin slices display over themselves. It's
relatively easy for me to check to see if I have more than one thin slice, but I
haven't found a way to move the labels so I can stop them from overprinting.

Is it possible to programmatically reposition the labels on a pie chart?

Using Excel XP, Windows XP.

--
Regards,
Fred




AA2e72E

Pie chart slices too thin
 
Have you considered an Exploded Pie Chart, this might give you the room for
the labels.

"Fred Smith" wrote:

For a pie chart that we habitually use, I sometimes get data like 96%/1%/1%/1%.
In this case the text labels of the thin slices display over themselves. It's
relatively easy for me to check to see if I have more than one thin slice, but I
haven't found a way to move the labels so I can stop them from overprinting.

Is it possible to programmatically reposition the labels on a pie chart?

Using Excel XP, Windows XP.

--
Regards,
Fred





Fred Smith

Pie chart slices too thin
 
It's already exploded. They still print on top of each other if two or more
slices are too thin.

--
Regards,
Fred


"AA2e72E" wrote in message
...
Have you considered an Exploded Pie Chart, this might give you the room for
the labels.

"Fred Smith" wrote:

For a pie chart that we habitually use, I sometimes get data like
96%/1%/1%/1%.
In this case the text labels of the thin slices display over themselves. It's
relatively easy for me to check to see if I have more than one thin slice,
but I
haven't found a way to move the labels so I can stop them from overprinting.

Is it possible to programmatically reposition the labels on a pie chart?

Using Excel XP, Windows XP.

--
Regards,
Fred








All times are GMT +1. The time now is 03:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com