Rafiul Hasan
You may create a chart and add titles to the chart in an Excel workbook on the basis of some gathered data. But won’t it be nice to change the labels of the axis of the chart you have created in Excel? In this article, I will show you how to change axis labels in an Excel Spreadsheet.
Download Practice Workbook
3 Easy Methods to Change Axis Labels in Excel
In this section, you’ll find 3 easy ways for changing axis labels in an Excel workbook by using Excel built-in features. Let’s check them now!
1. Change Axis Label by Changing Data
Let’s say, we have got a dataset of sales and profit of the salesmen of a shop for a certain period of time.
We have made a chart describing the sales of the shop over the mentioned time period.
Here, for simplicity we’ve created a clustered column chart, feel free to proceed with your chart.
To change the labels by using this method, just follow the steps below:
- First of all, click the cell in the worksheet that you want to change the label.
- Then, type the label in the cell and press ENTER.
- Repeat the same for each cell and you will get the label changed.
So easy, isn’t it? These are the steps you can follow for changing the labels manually by changing the data in the cell.
Read More: How to Change Axis Titles in Excel (with Easy Steps)
2. Change Axis Label Without Changing Data
We will now learn how to change the axis label in a chart without changing the data. Here is our data and chart:
To change the label using this method, follow the steps below:
- Firstly, right-click the category label and click Select Data.
- Then, click Edit from the Horizontal (Category) Axis Labels icon.
- After that, assign the new labels separated with commas and click OK.
- Now, Your new labels are assigned. I’ve used numbers here, you can use anything you prefer. Click OK on the dialogue box.
- Here, you will get your axis label changed.
That’s how we can change the labels of an Excel chart without changing the data.
Read More: Excel Bar Chart Side by Side with Secondary Axis
3. Change Labels of Axis in a Chart by Changing Source
For our previous dataset, let’s change the axis labels by changing the source itself.
For changing the label of the vertical axis, follow the steps below:
- At first, right-click the category label and click Select Data.
- Then, click Edit from the Legend Entries (Series) icon.
- Now, the Edit Series pop-up window will appear. Change the Series name to the cell you want.
- After that, assign the Series value.
- Now, press OK on the dialogue box.
- Finally, you will get your axis label changed.
For changing the label of the Horizontal axis, follow the steps below:
- Firstly, right-click the category label and click Select Data> Click Edit from the Horizontal (Category) Axis Labels icon.
- Then, assign a new Axis label range and click OK.
- Now, press OK on the dialogue box.
- Finally, you will get your axis label changed.
That is how we can change vertical and horizontal axis labels by changing the source.
Read More: How to Add X and Y Axis Labels in Excel (2 Easy Methods)
Conclusion
This article taught us how to change axis labels in an Excel chart. I hope from now on, you can easily change axis labels in your chart when you need them. If you have any queries regarding this article, please don’t forget to leave a comment below. Have a great day!
