Show months, quarters AND years on the chart axis

Please purchase the course before starting the lesson.

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.

Back to: Intermediate Excel Course > Charting In Excel