Excel for Data Analysis and Visualization

Horizontal Axis- dates vs text, reverse order, show all labels

You don’t have access to this lesson

Please purchase this course, or sign in if you’re already enrolled, to access the course content.

The Horizontal Axis has a very important customisation option with regards handling dates and other useful options

Dates versus Text (or dates you would rather see as text)

To follow along go to 30.3

The first option available in the Format Horizontal Axis asks what it must do if it sees dates? This often causes confusion so it is important you understand it otherwise you may see dates on the chart that don’t exist in the data.

horizontal-axis-dates-vs-text-reverse-order-show-all-labels

Use Axis to show actuals vs budget?

You can specify where the vertical axis crosses the horizontal axis. horizontal-axis-dates-vs-text-reverse-order-show-all-labels

Tick marks, labels and number format

As with the vertical axis, you can customise your chart to the point where the tick marks can be inside or outside and the series can be between the tick mark or on the tick mark.

horizontal-axis-dates-vs-text-reverse-order-show-all-labels

To see the full course contents click here.

0 of 141 lessons complete (0%)
0
    0
    Your Cart
    Your cart is emptyReturn to Shop