How to Change X Axis Values in Excel

August 9, 2022
2.1K 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 X-axis and Y-axis in Excel/Spreadsheet WPS. Most people do not know how to change the values of X-axis of graphs in Excel/Spreadsheet WPS. It is very easy to change the values of X-axis in Excel/Spreadsheet WPS.


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


Different Ways to Change X-axis Values in Excel/Spreadsheet WPS

Change X-axis Values in Excel/Spreadsheet WPS Using Right Click

1.Open Excel/Spreadsheet WPS which contains the graph whose X-axis values you want to change. 

2.Right Click on the X-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 X-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 X-axis values graph will change based on the X-axis values.

Change X-axis Values Interval (Text Based) in Excel/Spreadsheet WPS

In case the data on X-axis is based on text then they can be changed by the following method.

1.Open Excel/Spreadsheet WPS which contains the graph whose X-axis values you want to change. 

2.Right-click on the X-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 X-axis values.

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

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

Hopefully, you have learned How to change X-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.