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

charts

ResolvedVersion 2007

Ben has attended:
Excel Introduction course

Charts

During the course I gave the chart a Coloured border around the page however the main body of the page remained white. I can't remember how I did it and forgot to ask at the time. Many thanks.

RE: Charts - Contexualized tab!!

Dear Ben

Thank you for attending Excel Intro course. I hope you enjoyed the course and benefited from it.

In Excel 2007 when you create a chart you automatically see a new Contextualized tab called Chart Tools on the top right hand side on the Ribbon. Within this Contextualized tab you have sub tabs namely Design, Layout and Format.

Design is to change the look of your chart very quickly such as changing to different type of chart or placing the chart as a new sheet or changing the styles of the chart. This affects the entire chart AND NOT specific elements of a chart!!

If you want to modify or display certain elements of the charts such as add Chart or x-axis or y axis titles or display values on the series, etc

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

Server loaded in 0.11 secs.