How to Create a Chart with the Axis having Two Categories

In many situations, you may need to have two categories on your Axis when working with the chart. Please follow the steps below:

Step 1: We use the table below in this example, and we have two categories: Quarter and Month.

Step 2: Select the data range A1:D7, and click the "Insert" Tab from the Ribbon;

Step 3: Click the "Column Chart" in the Charts area;

Step 4: You will get the chart with the axis having two categories: Quarter and Month.

Download Example

Leave a Reply