Add multiple pie charts in the same graph.
Solved
Ololyxes
Posted messages
60
Registration date
Status
Membre
Last intervention
-
via55 Posted messages 14730 Registration date Status Membre Last intervention -
via55 Posted messages 14730 Registration date Status Membre Last intervention -
Hello everyone,
I'm looking to create a chart combining several pie charts into one to show the distribution of my customer orders by year (over €1000 / under €1000). I do not want to create multiple identical charts but a single one that is easier to manipulate for pasting into a PowerPoint presentation, for example (same size, same color, ...).
Sample data:
2012
> €1000 = 40%
< €1000 = 60%
2013
> €1000 = 55%
< €1000 = 45%
2014
> €1000 = 35%
< €1000 = 65%
Thank you all for reading and for your help!
See you soon
Configuration: Windows 7 / Internet Explorer 8.0
I'm looking to create a chart combining several pie charts into one to show the distribution of my customer orders by year (over €1000 / under €1000). I do not want to create multiple identical charts but a single one that is easier to manipulate for pasting into a PowerPoint presentation, for example (same size, same color, ...).
Sample data:
2012
> €1000 = 40%
< €1000 = 60%
2013
> €1000 = 55%
< €1000 = 45%
2014
> €1000 = 35%
< €1000 = 65%
Thank you all for reading and for your help!
See you soon
Configuration: Windows 7 / Internet Explorer 8.0
1 réponse
Unfortunately, I don't believe Excel allows you to create multiple charts in one.
However, I have a solution to achieve the same result:
- you create a first chart (e.g., 2010) that you format and plan space for the two other pie charts
- you create the last two (2011-2012), but this time you remove the background/border, etc., so that you have strictly just the pie chart and the corresponding year
- you embed the two pie charts into the first chart
- you select the 3 "charts" as Excel groups (format->organize->group)
You will only have to update your data in the table and you'll have your nice three pie chart :)
I'll let you adapt this technique to your specific needs (you can define chart templates and save them, for example).
Good luck,
However, I have a solution to achieve the same result:
- you create a first chart (e.g., 2010) that you format and plan space for the two other pie charts
- you create the last two (2011-2012), but this time you remove the background/border, etc., so that you have strictly just the pie chart and the corresponding year
- you embed the two pie charts into the first chart
- you select the 3 "charts" as Excel groups (format->organize->group)
You will only have to update your data in the table and you'll have your nice three pie chart :)
I'll let you adapt this technique to your specific needs (you can define chart templates and save them, for example).
Good luck,
More simply:
Create the first chart and format it
Copy and paste it two times next to or below the previous one
In these last two, right-click Select Data and modify the data range
Finally, select the first chart, then while holding down CTRL, select the second and then the third, right-click and group
Best regards