side by side pies

[keith]

I would like to show two pies side by side

Billed charges to customers (showing percentage of totals
Receipts from customers (showing percentages of total receipts by customer

I would like the two pies to size based on their total

customer Charges Receipt
A 150 12
B 100 8
C 110 10

Chart of Charges would show total charges of 360 with the various percentage
Chart of Receipts would show total receipts of 317 with the various percentage
the chart of charges would be larger than the chart of receipts

 

[Jon Peltier]

Keith -

The easiest way is to make two separate pie charts, and shrink one with
respect to the other.

An alternative approach would be a stacked column chart, with series in
rows. The categories are Charges and Receipts, and each customer has his
own column in each stack. The total height of each stack shows the
difference between 360 and 317 more clearly than side by side pie charts.

And IMNSHO, a stacked bar chart is easier to interpret without
misrepresentation than a pie chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______