Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Charts

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Charts

Resolved · Low Priority · Version 2003

Reply Wed 11 Feb 2009, 15:29Delegate Toby said...

Toby has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Excel Introduction course
Excel Intermediate course

Charts

What is the short cut key to create a chart

For upcoming training course dates see: Pricing & availability

Reply Wed 11 Feb 2009, 15:50Trainer Amanda said...

RE: Charts

Hello Toby

Thank you for your question and welcome to the forum.

You can create a chart quickly by selecting the data you wish to have represented in the chart, then press the F11 key.

Kind regards
Amanda

Wed 18 Feb 2009: Automatically marked as resolved.

Excel articles

· How To Link Between Spreadsheets In Excel
· Sorting Out Your Data In Excel
· Find Out How To Create That Missing Link With Excel
· Using Dates Within Excel
· What's Better Than the Help Function in Excel? Microsoft Training

Please browse our web site to find out more about
vba for excel training and other Microsoft training courses.

Excel tip:

Converting an American date format to European using Formula

Excel depending on your local setting will only pick up date values of the dd mmm yyyy oders as date type. If you import data from various sources including America their date order is different with data value in mmm dd yyyy, excel can only treat it as text indicated by left aligning it. To overcome this you have to do the the following.

1. Extract the date components mmm dd yyyy, by using the the Text functions LEFT, MID or RIGHT

2. Reorder dd mmm component and concatenate using "&" in the right order this will create a text string with the date in the right order it then needss to be converted to a value so excel can recognise it.

3. To convert to value encase in TEXT function.

4. Format to desired date format.

View all Excel hints and tips