zaterdag 30 november 2013

Excel: Pie Chart With Two Different Pies

In Excel it looked impossible two create a pie chart with two different pies in one chart. And of course I did not want to paste two pies together. By using the type Pie of Pie I managed to do it. Could not yet find an example of this on the internet.

Here are the data from A1:D7:

Fruit Vegetables
Apples 1 Lettuce 7
Pear 2 Cabbage 8
Bananas 3 Spinach 9
Grapes 4 Endive 10
Cherries 5 Carrots 11
Strawberries 6 Sprouts 12

You can download the file through this link:

Een reactie posten