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.
- Create a Chart with Two-Level Axis Label
- Create a Chart with Two-Level Axis Label Based on Pivot Table
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.
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.
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.
Step3: keep the Expand the selection option be checked, and click Sort button in the Sort Warning dialog box.
Step4: the selected cells should be sorted.
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.
Step7: you need to repeat the step 5-6 to merger other adjacent cells with the same category of product.
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.
Step9: you would see that the column chart with two-level Axis labels has been created successfully.
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.
Step2: check the Existing Worksheet option and select a blank cell to place your pivot table in your current worksheet, and click Ok button.
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.
Step5: you would see that the column chart with two-level Axis labels has been created successfully.