How to Create a Chart with Two-level Axis labels in Excel

This post will guide you how to create a column chart with two-level Axis labels based on your original data in Excel. How do I create a Two-level X axis labels in your Chart with Pivot table in Excel 2013/2016.

Assuming that you have a list of data, and you want to create a column chart with two-level X Axis labels. This post will introduce two ways to achieve the result. You need to change the original data in the First method, including sorting and merging cells. And a pivot table need to be created based on your data, then create a Column Chart based on Pivot table.

create chart with two level axis1

Create a Chart with Two-Level Axis Label


You need to change the original data firstly, and then create column chart based on your data. Just do the following steps:

Step1: select the first column (product column) except for header row.

create chart with two level axis2

Step2: go to DATA tab in the Excel Ribbon, and click Sort A to Z command under Sort & Filter group. And the Sort Warning dialog will open.

create chart with two level axis3

Step3: keep the Expand the selection option be checked, and click Sort button in the Sort Warning dialog box.

create chart with two level axis4

Step4: the selected cells should be sorted.

create chart with two level axis5

Step5: select the first same category of product in the first column, such as: Excel.

Step6: go to Home tab, and click Merge & Center command under Alignment group. And the Microsoft Excel warning dialog box will open. And Click Ok button. And the first product should be merged into one cell.

create chart with two level axis7

create chart with two level axis8

Step7: you need to repeat the step 5-6 to merger other adjacent cells with the same category of product.

create chart with two level axis9

Step8: select your current source data, and go to Insert tab, click Insert Column Chart command and select Clustered Column from the dropdown list box.

create chart with two level axis10

Step9: you would see that the column chart with two-level Axis labels has been created successfully.

create chart with two level axis11

 

Create a Chart with Two-Level Axis Label Based on Pivot Table


You can also create a Column Chart with two-level axis labels based on a pivot table in your worksheet, just do the following steps:

Step1: select your source data, and go to Insert tab, click PivotTable command under Tables group.

create chart with two level axis12

Step2: check the Existing Worksheet option and select a blank cell to place your pivot table in your current worksheet, and click Ok button.

create chart with two level axis13

Step3: choose product, data, sales fields in the PivotTable Fields pane. And the pivot table should be created based on your source data.

Step4: select your pivot table, and go to Insert tab, click Insert Column Chart command and select Clustered Column from the dropdown list box.

create chart with two level axis14

Step5: you would see that the column chart with two-level Axis labels has been created successfully.

 

You might also like:

Comments

So empty here ... leave a comment!

Leave a Reply

Your email address will not be published. Required fields are marked *

Sidebar