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.
To present this data in a chart, you will enter the sales values shown over the period.
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.
- Enter the label in the cell and press ENTER key.
- You need to repeat the process for all cells one by one and you will notice the labels are changing.
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:
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.
- A dialog box Select Data Source will appear. Click the Edit button from the Horizontal Axis Labels box.
- Now, add the labels you need in the Axis label range box that separates by commas.
- Add arbitrary labels in the Axis label range.
- Press OK to save changes in the chart axis labels change.
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.
- Select the Edit option given in the Legend Entries menu.
- The Edit Series window pops up. Now, change the Series name you need.
- Now, assign the Series value.
- Press OK.
- You will see the Axis label is now changed.
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.
- Assign a new Axis label range and click OK.
- Press OK.
- Finally, you will notice the axis label is changed.
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.
