vba excel - Excel spreadsheet

The UK's most regular instructor-led training courses.
Training information: vba excel · Excel in courses · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Excel spreadsheet

Naomi has attended:
Powerpoint Advanced course
Excel Intermediate course

by - delegate Naomi [2 posts] (2007 Sep 20 Thu, 09:56) Reply

How do I create a pie chart?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Nov 21 Fri	Bloomsbury	3	book now	£224	£235
2007	2008 Nov 27 Thu	Bloomsbury	4	book now	£240	£245
2003	2008 Nov 28 Fri	Southwark	1	book now	£235	£240
2003	2008 Dec 3 Wed	Bloomsbury	3	book now	£224	£235
2003	2008 Dec 5 Fri	Bayswater	6	book now	£195	£205
2002/XP	2008 Dec 10 Wed	Tooting	0	FULL
Full Schedule: See all 99 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Excel spreadsheet

by - trainer Anthony gold contributer [113 posts] (2007 Sep 25 Tue, 16:47) Reply

Hi Naomi. Very simply, select the data you want to convert into a chart and then select Insert - Chart (or the "column chart" icon on your toolbar). The Chart Wizard will start and you can select a pie chart from the list on the left hand side.

Hope this helps,

Anthony

· Microsoft Excel's Best Kept Secret
· Advanced level training: Microsoft Excel and the Web
· Training Budgets In A Bad Economy
· Benefits of learning about Excel charts
· Tools From Advanced Excel Courses: Goal Seek and Solver

Excel tip:

Showing all menu items

If you go into a pull down menu you usally find that you get a selection of items(this is the default) or sometimes everything. If you only get a selectiopn you have to go to the double arrows at the bottom of the menu and click it to get all of the hidden items.
To turn this off so that you always get everything, go to Tools / Customize / Options Tab / "Always show full menus". Make sure there is a tick in the box and you will always have every item.

View all Excel hints and tips