Suzi has attended:
Excel Intermediate course
Excel - creating a pie chart
Hiya, I need to put two pie charts side by side each other but I can only seem to create two separate charts. Can you tell me how to do this?
RE: Excel - creating a pie chart
Hi Suzi
Thank you for your question. The answer is to make two pie charts and position them side by side as far as I'm aware.
If you want them on a different sheet click on a chart use the Move Chart button on the far right of the Design ribbon found on the green Chart Tools Ribbon.
This will let you move each of them to a different sheet where they can be positioned alongside each other.
Is this the effect you are looking for? Let me know if this doesn't answer your question and I can investigate further for you.
Kind regards,
Andrew
RE: Excel - creating a pie chart
Hi Andrew, thanks for getting back to me so promptly. Not sure I explained what I was trying to do very clearly.
So, in Excel when you create a pie chart you enter the data, click on the pie chart icon and that automatically creates the pie chart.
I'm trying to create two identical pie charts to compare side by side (different numbers but identical format) but I want them side by side in the same box, not in two separate boxes which is what I have now. I need to be able to run an arrow between the two charts to illustrate how one set of data has been improved compared to the other.
Does that make sense?
RE: Excel - creating a pie chart
Hi Suzi
I understand - unfortunately making two pie charts and aligning them alongside each other is the only way I'm aware of to achieve this effect. To make them look like they are in the same box you could click each chart then go to the Format Ribbon in Chart Tools and set the Shape Outline to none. Then you can overlap the two shapes. With them both selected Right click and choose group.
Excel will now treat both charts as one object.
Let me know if this gets you closer to the effect you are looking to achieve?
Kind regards,
Andrew
