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.