Hi,

I have made a pie chart using a macro... the problem is i also want to
display the percentage with the chart.

Now for some reports there are times when there are many small values....so
the chart gets messy with all the values overlapping........ i have to make
many pie's that way and cant really sit and correct each one of it.........

can somebody suggest something???

Aziz

Hi,

The only really useful suggestion would be to use a different chart
type. If your chart has lots of slices the reader will not be able to
tell the difference between slices or see them because of the labels.

There is no built in way to improve on the best fit option.

Cheers
Andy

Aziz Ahmedabadwala wrote:
Hi,

I have made a pie chart using a macro... the problem is i also want to
display the percentage with the chart.

Now for some reports there are times when there are many small values....so
the chart gets messy with all the values overlapping........ i have to make
many pie's that way and cant really sit and correct each one of it.........

can somebody suggest something???

Aziz

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info