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:
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 ExcelTwoCircles.zip through this link:
Reacties