Home // Blog & Excel Tips // Date Axis on Excel charts and graphs

Images loading below. While you wait, can you answer this Excel related tip? Guess the answer then click SEE ANSWER to see how it can be done.

1. How do you take all the formatting from chart (see 1 below) and PASTE it onto another chart (2)? Guess and then see how it can be done with 'See Answer'

 
2. What is the shortcut to ONLY select the visible cells? Guess, then click 'See Answer' as it can be done.

 

Date Axis on Excel charts and graphs

Comments Closed
Uncategorised

If Excel recognizes that your horizontal axis is a date, it automatically assumes you want the axis to use dates. As a result, for example, if you have date data that goes from Monday to Friday, when you plot it, the graph may show Saturday and Sunday  with blanks (even though you don’t want to show it).

To correct this you need to right click on the horizontal axis and adjust the settings. In this area you will see an option which tells Excel whether it must automatically detect dates, always treat as text, or always treat as dates.

Depending on which option you choose, the horizontal axis will show the details in the way you want.

 

Learn more at our live advanced Excel courses in South Africa. Visit www.AuditExcel.co.za Live Excel Training page