How to Change X-Axis Labels in Excel – Horizontal Axis

  • Home
  • / How to Change X-Axis Labels in Excel – Horizontal Axis

Talking about Axis in Excel, you will notice words and numbers along with the horizontal or X-Axis, whereas the vertical or Y-Axis has values in a chart. You can drag category axis labels or X-axis labels directly from the headings added in the dataset of the chart. On the other hand, the values axis or Y-axis labels are analyzed on the basis of data given in the chart.

What if you need to change axis labels in Excel?

In this post, you will get to know how to change X-Axis labels in Excel. Whenever your data updates, you need to change the categories in a chart and for this you have to change the horizontal axis. With multiple intervals, the X-axis shows dates or texts. You will not find numeric values.

Around four to six, you can add the number of datasets to present in a visible chart. In case, when you have more datasets, try presenting them in more than one chart.

How to Change X-Axis Labels in Excel by Changing Data?

Suppose you have a dataset containing sales and salesmen profits collected from a certain period.

axis data

To present this data in a chart, you will enter the sales values shown over the period.

axis data2

According to the data, you can use a clustered column chart. For changing labels, let’s follow the steps given below:

  • First, choose a cell from the sheet in which you need to change the labels.

axis data3

  • Enter the label in the cell and press ENTER key.

axis data4

  • You need to repeat the process for all cells one by one and you will notice the labels are changing.

axis data5

All done!

Isn’t it that quick?

By following the above steps, you can easily change the labels manually in the cell.

Let’s move on to another method:

Price banner Earn and Excel

How to Change X-Axis Labels in Excel without Changing the Data?

In the above method, you can see the data was being changed while changing the x-axis labels. In this method, you will learn how you can change labels without changing the data from the sheet. Let’s get started:

  • Right-click the X-axis in the chart in which you need to change labels.
  • Choose the Select Data option from the Context Menu.

select data

  • A dialog box Select Data Source will appear. Click the Edit button from the Horizontal Axis Labels box.

select data source

  • Now, add the labels you need in the Axis label range box that separates by commas.

axis label range

  • Add arbitrary labels in the Axis label range.
  • Press OK to save changes in the chart axis labels change.

axis label

How to Change X-axis Labels in Excel by Changing Source?

Considering the above dataset, let’s get to know how you can change X-axis labels by changing the source. Below are the steps you need to follow:

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

axis changing source

  • Select the Edit option given in the Legend Entries menu.

axis changing source2

  • The Edit Series window pops up. Now, change the Series name you need.

axis changing source3

  • Now, assign the Series value.

axis changing source4

  • Press OK.

axis changing source5

  • You will see the Axis label is now changed.

axis changing source6

To change the Horizontal axis label, below are some easy-to-follow steps:

  • Right-click the category label and choose Select Data. Click on the Edit button given in the Horizontal Axis Labels menu.

axis changing source7

  • Assign a new Axis label range and click OK.

axis changing source8

  • Press OK.axis changing source9
  • Finally, you will notice the axis label is changed.

axis changing source10

Now, you have come to know how to change X-axis labels in Excel by source change.

Let’s Wrap Up:

In this post, you learned how to change axis labels in a chart. Hopefully, the above data explains perfectly and you are now familiar enough with the solution. Try all of the above methods and you will learn Excel.

Price banner Earn and Excel

Write your comment Here