Hessel de Walle's Blog

Bubble or pie chart or both? With the help of Excel VBA everything is possible! Here are the data: Bubble X Y Size A 1 3 3 B 3 3 3 C 3 1 4 D 1 1 2 Pie 1 Pie 2 Pie 3 Pie 4 8 5 3 8 5 1 7 2 6 2 4 3 4 4 3 3 5 5 3 2 You can download the file  ExcelGrafiekBel.xlsm  through https://drive.google.com/folderview?id=0B7HgkOwFZtdZVmhRQUZFM28yc1U&usp=sharing

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  ExcelTwoCircles.zip  through this link: https://drive.google.com/folderview?id=0B7HgkOwFZtdZVmhRQUZFM28yc1U&usp=sharing