98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel - creating a pie chart
Excel - creating a pie chart
Resolved · Urgent Priority · Version 2010
Fri 8 Feb 2013, 12:52Delegate Suzi said...
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?
Fri 8 Feb 2013, 14:33Trainer Andrew said...
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
Fri 8 Feb 2013, 14:54Delegate Suzi said...
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?
Mon 11 Feb 2013, 15:56Trainer Andrew said...
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Calculate age or serviceThe DATEDIF() function in Excel calculates the number of days, months, or years between two dates. So, this function makes it easy to calculate a person's age. To try this tip: |
