- Trending Categories
- Data Structure
- Operating System
- MS Excel
- C Programming
- Social Studies
- Fashion Studies
- Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How do group (two-level) axis labels in a chart in Excel?
Excel is a popular spreadsheet software that allows users to develop, organize and analyze data, by using different available options such as tables, charts, and graphs. The most common benefit of using the chart is that it allows the user to analyze data easily, compare data becomes easy, and make conclusions fast and easy to understand by all. Nowadays, many interactive ways are available in Excel to make a presentable chart within a few seconds. In this article, grouping axis labels in a chart by using Excel, can be done by using two examples. The first example uses a chart, while the second example uses a “pivot chart” to perform the same task.
Example 1: To group the two-level axis label in Excel by using the chart
To create a group of the (two-level) axis, by using the chart in Excel. Consider the below provided Excel spreadsheet. This worksheet contains three columns with the name “product name”, “date”, and “sale”.
Before, creating a graph sorting data is necessary. To do so, go to the “Home” tab, and click on the “Editing” option. Under this option select the “Sort and filter” option and select “Sort A to Z”. consider below-given image for proper reference −
This will open a “Sort Warning” dialog box. In this dialog box, select the first option ‘Expand the selection, and then click on “Sort” option.
In the provided data Product A1 is written in two rows. So, to clarify the data in the graph user need to merge the name of cells containing the same product name. To do so, go to the “Alignment” section, and click on the “Merge & Center” option. This will merge the two same rows.
This will display a “Microsoft Excel” dialog box, with a warning for merging cells. simply click on the “OK” button, to merge the same name records.
Check the obtained results below. Perform the same for other available products as well.
In the “Insert” tab, click on the chart section, and from the “2D” section select the first graph option. Consider the below image for proper understanding −
This will display the graph, as shown below. Please note that the user can drag the graph to any required space and label and axis style and color can be modified by using the different available chart styles.
Example 2: To group the two-level axis label in Excel by using the pivot table
To create a group of (two-level) axis, by using the pivot table and chart option in Excel. Consider the below provided Excel spreadsheet. This worksheet contains three columns with the name “product name”, “date”, and “sale”. For, this example consider the merged data, as provided below. Go to the “Insert” tab, select the pivot chart, and choose the first available option, as depicted below −
This will open a “Create PivotTable” dialog box. Tick on the “Select a table or range” option, and select the table data from the sheet. After that select the “Existing sheet” option. This will display the graph on the existing sheet. Finally, click on the “OK” button.
This will open the “PivotTable Fields” dialog box, as depicted below. After that in the “Rows” section drag the column values for “product name”, and “date”. Finally, in the “values” option select the “sum of sales” option.
After setting all the previous options the below-provided graph will be displayed. Please note that the user can drag the graph to any required space and label and axis style and color can be modified by using the different available chart styles.
The examples provided in this article are based on the use of two different strategies to create the same graph. This article contains two examples so that learners will understand all the possible ways to do the provided task.
Kickstart Your Career
Get certified by completing the courseGet Started