Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

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

Charts

ResolvedVersion 2003

Mon 23 Feb 2009, 16:43 Delegate Eileen said...

Eileen has attended:
Excel Intermediate course
Excel Introduction course

Charts

what are the easy steps to create a pie chart

Tue 24 Feb 2009, 11:34 Trainer Amanda said...

RE: charts

Hello Eileen

Thank you for your question.

To create a pie chart quickly and easily:
1. Select the data you'd like to have represented in the chart.
2. Press the F11 key on your keyboard. This will automatically create a column chart of the selected data.
3. Go to Chart-Chart Type on the menu, and select Pie as the chart type and click OK (to change from a column chart to a pie chart).

Kind regards
Amanda

Mon 2 Mar 2009: Automatically marked as resolved.

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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Charts

Charts

RE: charts

Excel articles

Excel tip:

Calculate difference between two times