Charts

Resolved · Low Priority · Version 2003

Charts

Meridith has attended:
Excel Intermediate course

by - delegate Meridith [1 post] (2008 May 27 Tue, 16:28) Reply

I always end up with multiple pie charts. For example, I want to show the breakdown of our customers by age and then by hobby. Is it possible to have pie pieces with subsections?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue	Bloomsbury	0	FULL
2003	2008 Nov 27 Thu	Southwark	3	book now	£210	£215
2007	2008 Nov 28 Fri	Bloomsbury	0	FULL
2003	2008 Dec 2 Tue	Bloomsbury	4	book now	£207	£215
2003	2008 Dec 4 Thu	Bayswater	6	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	5	book now	£212	£224
Full Schedule: See all 113 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: charts

by - trainer Richard platinum contributer [813 posts] (2008 May 28 Wed, 12:20) Reply

Hello Meredith,

Hope you enjoyed your Microsoft Excel course with BEST Training.
Thank you for your question regarding Charts.

Pie charts are fairly limited in their ability to contain anything more than one series of data.

You might consider using a pie chart combined with a secondary pie or column chart, or alternatively exploring a doughnut chart, which can contain more than one series.

For your reference, I suggest you review the following artile from Microsoft and see if it is helpful.

http://office.microsoft.com/en-us/excel/HA011179371033.aspx?pid=CL100570551033

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Richard
Microsoft Office Specialist Trainer

· Reporting and Analysis with Excel
· Compare Different MS Excel Training Methods
· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel
· How Excel Training Can Improve Your Company's Sales Process
· Creating Charts with Excel

Please browse our web site to find out more about
vba excel course london and other Microsoft training courses.

Excel tip:

Reconciling a list to correspond with another

May have a list that needs to make but on another sheet one list seems to be out, eg. product list one sheet contains all product and inventory data, while the other contains pricing data. Both need to match with all products but there is more products in one list than the other. To find the disparaging product compare data in the two columns that need to match Make sure that order the same way.
Create another column in the sheet that has the most items and type in the first cell

=Exact(text1,text2) text1 being the cell that you want compared with text2 cell reference. Drag to filldown and your first false will give you for first cells that does not match. Correct insert the row with data in other sheet and continue the process until all the data returns true. Delete the column inserted.

View all Excel hints and tips