excel training course london - Graphs / tables

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

Resolved · Low Priority · Version Standard

Graphs / tables

Hayley-jayne has attended:
Excel Intermediate course
Excel Intermediate course
Excel Advanced course

by - delegate Hayley-jayne [7 posts] (2007 Mar 2 Fri, 09:51) Reply

what is the easiest way to create a table or graph in Excel.

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

RE: graphs / tables

by - trainer Tracy platinum contributer [586 posts] (2007 Mar 2 Fri, 11:11) Reply

The quickest and most basic way to create a graph from table in Excel is to click within your data table and press the F11 button. From there you can format you chart as required.

Good luck

Tracy

· Identifying Suitable Candidates For VBA For Excel Training
· Basic Excel Training
· Microsoft Excel Cheat Sheet: Tips and Shortcuts
· MS Excel: Excel At Making The Most Of Your Christmas
· How to Create Better Excel Spreadsheets: Part Two

Excel tip:

Cycling through Absoulte cell references

If you are working with formulas in excel and need to convert your formula to an absolute formula, instead on manually adding in the $dollar signs you can highlight the specific part of your formula and press the F4 key.

You can cycle through all the absolute options by pressing the button (up to four times)

View all Excel hints and tips