Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training in uk - Chart

excel training in uk - Chart

ResolvedVersion Standard

Thu 13 Sep 2007, 09:45 Delegate Louise said...

Louise has attended:
Excel Advanced course

Chart

how do you create a chart?

Mon 24 Sep 2007, 13:10 Trainer Katie said...

RE: chart

Hi Louise,

Thank you for your question.

To create a chart:
1) Highlight the data - i.e. list of labels & numbers
2) Press F12 on your keyboard
3) Change Chart Option for: chart type / axis lables / background colour / legend box position...etc

Hope this helps.

Katie

Mon 24 Sep 2007, 17:27 Delegate Louise said...

RE: chart

Thanks, but I think F12 is 'save as'?

Tue 25 Sep 2007, 09:16 Trainer Katie said...

RE: chart

Sorry I meant F11.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Calculate difference between two times

For presenting the result in the standard time format (hours : minutes : seconds . Use the subtraction operator (-) to find the difference between times, and the TEXT function to format the returned value to text in a specific number format.

Hours never exceed 24, minutes never exceed 60, and seconds never exceed 60.

=TEXT(B2-A2,"h")
Hours between two times (4)

=TEXT(B2-A2,"h:mm")
Hours and minutes between two times (4:55)

=TEXT(B2-A2,"h:mm:ss")
Hours and seconds between two times (4:55:00)

Where B2 and A2 must hold the end time and start time respectively formatted as a time format

View all Excel hints and tips

excel training in uk - Chart

Chart

RE: chart

RE: chart

RE: chart

Excel articles

Excel tip:

Calculate difference between two times