How to Change Horizontal Axis Values in Excel

August 9, 2022
2.2K Views
0

A free Office suite fully compatible with Microsoft Office

Free Download

Often when we are working in Excel/Spreadsheet WPS, we have to make graphs of the data in order to have a clear depiction of the data and to understand the data more easily. Graphs in Excel/Spreadsheet WPS are made with the selected data. Sometimes, when we are shared some excel/spreadsheet files, we have to make changes to the graphs. Changing the graphs involves changing the values of Horizontal Axis and Vertical axis in Excel/Spreadsheet WPS. Most people do not know how to change the values of Horizontal Axis of graphs in Excel/Spreadsheet WPS. It is very easy to change the values of Horizontal Axis in Excel/Spreadsheet WPS.


In this topic, we will discuss different methods by which we can change Horizontal Axis Values in Excel/Spreadsheet WPS OFFICE(2016/2019/Mac/Online). It is very easy to change Horizontal Axis values in Excel/Spreadsheet WPS OFFICE(2016/2019/mac/online) and then you can easily change the graphs as per your requirements.


Different Ways to Change Horizontal Axis Values in Excel/Spreadsheet WPS

Change Horizontal Axis Values in Excel/Spreadsheet WPS Using Right Click

1.Open Excel/Spreadsheet WPS which contains the graph whose Horizontal Axis values you want to change. 

2.Right Click on the Horizontal Axis of the graph. A menu will open.

3.Click on Select Data option. A new window will open.

4.Under the Axis Labels (Category), click on the Edit button. A small window named Axis Labels will open.

5.Click on the highlighted button to select your desired range of data (values) for the Horizontal Axis.

6.After selecting the values, again click on the same button or press Enter.

7.Now click on OK and then your graph’s Horizontal Axis values graph will change based on the Horizontal Axis values.

Change Horizontal Axis Values Interval (Text Based) in Excel/Spreadsheet WPS

In case the data on Horizontal Axis is based on text then they can be changed by the following method.

1.Open Excel/Spreadsheet WPS which contains the graph whose Horizontal Axis values you want to change.

2.Right-click on the Horizontal Axis and then click on Format Axis

3.Now click on Axis Options button and in the Labels option, under Interval between labels, select Specify Interval Unit and type your desired interval value in the box next to it.

4.Close the window and the desired changes will be made to the Horizontal Axis values.

Note: This method only gives the options of text to be displayed on the Horizontal Axis and does not change the value of Horizontal Axis.

This article has covered the methods on How to change Horizontal Axis values in excel (2016/2019/Mac/Online) and How to change Horizontal Axis values (text based) in Excel/Spreadsheet WPS (2016/2019/Mac/Online). You can use these simple steps as explained above and easily change Horizontal Axis values in your WPS Excel/Spreadsheet (2016/2019/Mac/Online) whenever required.

Hopefully, you have learned How to change Horizontal Axis values in WPS Excel/Spreadsheet (2016/2019/Mac/Online).  If you want to know more about Excel features, you can follow WPS Academy to learn. You can also download WPS Office to edit the word documents, excel, and PowerPoint for free of cost. Download now! And get an easy and enjoyable working experience.