advanced.excel - Chart

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

Resolved · Low Priority · Version Standard

Chart

Holly has attended:
Excel Intermediate course

by - delegate Holly [1 post] (2007 Aug 21 Tue, 09:51) Reply

How do you enter a chart

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: Chart

by - trainer Tracy platinum contributer [586 posts] (2007 Aug 22 Wed, 05:22) Reply

Hi Holly,

Thanks for the question.

You can create a chart by putting your active cursor in the data you wish to convert to a graph and using the chart wizard. This is a button on your toolbar which looks like a miniture chart. Here you have a four stage procedure where at each stage you can change the settings of your chart until you are happy with it and you press "finish". Alternatively pressing F11 will also create a standard graph.

Tracy

· Compare Different MS Excel Training Methods
· Why Should I Learn Visual Basic in Excel?
· From the Classroom to the Corporate World
· Reasons Why VBA for Excel Training Fails
· Excel Macros for the Non-Programmer

Excel tip:

Highlighting only Text cells

To select onlt text value cells in a spreadsheet, click on Edit-Go to(F5)

In the Go To dialog box, click Special.
In the Go To Special dialog box, select Constants.
Click OK.

View all Excel hints and tips