Date Axis on Excel charts and graphs

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 Live Excel Training page