Proportionate Sized Pie Charts

[Mtyler]

All

I am looking to create pie charts which are proportionately sized (based on total).

For example:

Data Set 1

Debt 1 - 10m
Debt 2 - 20m
Debt 3 - 30m

I would like this data to be one pie chart, and the size of the pie be equal to 60m

Data Set 2 (total is equal to Debt 3, ie 30m)

Recovery - 20m
Write off - 8m
Fees 2m

I would like this data to be the second pie chart, and the size of the pie be equal to 30m (ie half the size of the first).

I'm using Excel 2007 and struggling slightly with the new chart set-up. I've tried to use the pie from pie function, but with no success. Would I be better to use 2 different pie charts?

Any ideas appreciated.

Thanks

Matt

 

[Willem!]

Hi!

Maybe thiz tutorial would help out...

 

[Mtyler]

That may work, although I can see any kind of tutorial there...

 

[Willem!]

...you'll have to download the attachement...

you can find it above the message itself:

Bubble Pie Chart
Posted on 01/04/05 03:42 PM Attachement (177 downloads)
Posted by KingMartin - Utter Access Editor
Posts: 10323 - Loc: Prague,CZ / Kiev,UA

 

[Mtyler]

I've downloaded the attachment, but there is no step by step process in there, just a spreadsheet with source data and the chart...