is there a way of setting the radius or the area of a pie chart in excel, in
centimetres or some other equivalent?
i am asking this as i need to create a series of pie charts that are
proportional to the amount of data that is in them.
is there a way of setting the radius or the area of a pie chart in excel, in
centimetres or some other equivalent?
i am asking this as i need to create a series of pie charts that are
proportional to the amount of data that is in them.
Hi anson,
You will need some code to help with this.
Have a look at the example.
http://www.andypope.info/ngs/ng34.htm
Cheers
Andy
anson wrote:
> is there a way of setting the radius or the area of a pie chart in excel, in
> centimetres or some other equivalent?
>
> i am asking this as i need to create a series of pie charts that are
> proportional to the amount of data that is in them.
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks