How to Change Axis Labels in Excel (3 Easy Methods)

Get FREE Advanced Excel Exercises with Solutions!

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.

Dataset for Changing Axis Labels

We have made a chart describing the sales of the shop over the mentioned time period.

Chart for Changing Axis Labels

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.

Changing Axis Labels

  • Then, type the label in the cell and press ENTER.

Change Axis Labels in a Chart

  • Repeat the same for each cell and you will get the label changed.

Change Axis Labels in Excel

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:

Change Axis Labels in a Chart in Excel

To change the label using this method, follow the steps below:

  • Firstly, right-click the category label and click Select Data.

Changing Axis Labels in Excel

  • 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.

Change axis Labels in an Excel sheetThat’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!


Related Articles

Rafiul Hasan
Rafiul Hasan

Hey there! I am Md. Rafiul Hasan. Currently, I am working as an Excel & VBA content developer. I like new ideas and want to explore the field of innovation. Excel has saved our work time and made it easy for us to perform quick calculations. I am trying to make it easier for you to overcome the obstacles you face while working on Excel. Stay connected!

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo