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


How to Change Axis Labels in Excel: 3 Easy Methods

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


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.


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.

To change 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


Download Practice Workbook


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


<< Go Back To Label Axis in Excel | Excel Chart Elements | Excel Charts | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Rafiul Hasan
Rafiul Hasan

Rafiul Hasan, holding a BSc in Naval Architecture and Marine Engineering from Bangladesh University of Engineering & Technology, contributes significantly to the ExcelDemy project with almost 1.6 years of dedicated work. Currently an Excel and VBA Content Developer, he has a passion for problem-solving. Authoring over 100 articles for ExcelDemy showcases expertise in Microsoft Office Suites and Data Analysis. In addition to content development, Rafiul actively engages with the ExcelDemy forum, offering valuable solutions to user queries and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo