microsoft excel xp training - Chart

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

Resolved · Low Priority · Version Standard

Chart

Tania has attended:
Excel Intermediate course
Powerpoint Introduction course

by - delegate Tania [1 post] (2007 Feb 27 Tue, 09:50) Reply

How do I create a chart from scratch?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue + 26 Wed	Bayswater	6	book now	£455	£515
2003	2008 Nov 26 Wed + 27 Thu	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 1 Mon + 2 Tue	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	5	book now	£450	£485
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	5	book now	£475	£515
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	6	book now	£450	£475
Full Schedule: See all 37 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: chart

by - trainer Tracy platinum contributer [586 posts] (2007 Feb 27 Tue, 10:59) Reply

Hi Tania,

There are a few ways you can do this, the first one is to click into your data table and press F11, this will create a standard column chart which you can edit. (Use the option on the menu bar that says Chart and you will see different ways to edit your graph/chart)

You could also use the chart wizard which is a button which looks like a graph on your screen, this gives you steps to add in different styles of graph, labels, titles etc.

Good luck and I hope it helps

Tracy

· Excel in the Home Office
· Microsoft Excel Training: Not Just for Newbies Anymore
· Identifying Suitable Candidates For VBA For Excel Training
· Database Tips from an Excel Training Course
· Tools From Advanced Excel Courses: Goal Seek and Solver

Excel tip:

Quickly copy a formula across sheets

Suppose you have a formula in cell Sheet1!B2, say =A1*5%, that you wish to copy to cell B2 on Sheet2, Sheet3 and Sheet4. Instead of using copy and paste, try this: (1) Select Sheet1!B2. (2) Group Sheet1 with the worksheets Sheet2, Sheet3 and Sheet4 by holding down Ctrl and clicking on the tabs of the sheets to group them. (3) Press the F2 key, then immediately press Enter to copy the formula in Sheet1!B2 across the grouped sheets.

Remember to ungroup the sheets afterwards! Right-click on any tab and choose Ungroup Sheets to do that.

View all Excel hints and tips