How to Change Horizontal Axis Values in Excel 2016
You can easily change the X-axis values/labels by editing your data labels. You can select new data to replace the existing X values. Check out the written instructions here: https://www.absentdata.com/change-the...
If your Excel version looks different, here is an alternate way!
• Change the X axis in Graphs in Excel...
Your data is broken up into two dimensions, these are the X-axis and the Y-axis. You can use the information by using the
1.Select Data
2. In the Horizontal (Category) Axis Labels box, click Edit.
3. In the Axis label range box, enter the labels.
Contact me on LinkedIn
