excel training microsoft

excel training microsoft - Excel Charts

Resolved · Low Priority · Version Standard

Excel Charts

Henry has attended:
Excel Intermediate course

by - delegate Henry [1 post] (2008 Jan 25 Fri, 17:01) Reply

How do you enter data for a pie chart with a pie chart as a subdivision of one segment. Pie chart types top row right hand side

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu	Bayswater	2	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	2	book now	£224	£224
2007	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 9 Tue	Tooting	0	FULL
2003	2008 Dec 11 Thu	Southwark	7	book now	£188	£215
2007	2008 Dec 16 Tue	Bayswater	6	book now	£207	£215
Full Schedule: See all 109 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Excel Charts

by - trainer Mark gold contributer [275 posts] (2008 Feb 1 Fri, 15:24) Reply

Hi Henry

To create an excel pie chart with the appropiate segments
from the chart wizard screens when you have selected the pie chart on the left hand side of the screen, you will see the appropiate subdivision pie chart

The types of charts you will need are either the exploding pie or the exploding pie 3D, the mre categories of data you have the more segments you will have and to define them more you will need to drag the segments of the chart as needed

hope this solves your problem

Mark East

· Tips to Facilitate Printing of Excel worksheets
· Interesting Lifestyle Applications for Microsoft Excel
· Training Budgets In A Bad Economy
· Excel in the Home Office
· 3 Reasons Why Excel Training Courses For Employees Can Improve Your Business

Excel tip:

Transpose text

You can transpose any range of cells, turning the columns into rows and the rows into columns. Just follow these steps:

Select the range.

Click the Copy button on the Standard toolbar to copy it to the Clipboard.

Select a cell outside of the range you copied.

Select Paste Special from the Edit menu.

In the Paste Special dialog box, click Transpose, then OK.

View all Excel hints and tips

Rate this page: