Excel for Data Analysis and Visualization

Show months, quarters AND years on the chart axis

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.

It is possible to add more information onto your horizontal axis. If you have the months shown, you can add quarters and years onto the same axis to make it more meaningful and easier to read.

Change where the horizontal axis gets its information

show-months-quarters-and-years-on-the-chart-axis

Add more information to the horizontal axis

What if we have monthly dates as shown below, but we want to show which quarter they belong to.

Below we have drawn onto the chart what we want to see.

show-months-quarters-and-years-on-the-chart-axis

show-months-quarters-and-years-on-the-chart-axis

Let’s try a third level. show-months-quarters-and-years-on-the-chart-axis

To see the full course contents click here.

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