charts

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Charts

Charts

resolvedResolved · Low Priority · Version 2003

Meridith has attended:
Excel Intermediate course

Charts

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?

RE: charts

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

 

Training courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Select blank cells automatically

Get Excel to find any blank (empty) cells in a region for you by:

1. Selecting the appropriate region from your spreadsheet.

2. On the menu bar, go to Edit - Go to.

3. Click the 'Special' button, then select Blanks and click OK.

View all Excel hints and tips


Server loaded in 0.08 secs.