How to Change Horizontal Axis Values – Excel & Google Sheets
Written by
Reviewed by
This tutorial will demonstrate how to change Horizontal Axis Values in Excel and Google Sheets
How to Change Horizontal Axis Values in Excel
Starting with your Graph
In this tutorial, we’ll start with a Scatterplot that is showing how many clicks a website gets per week.
As you can see, our date is on the X Axis and Clicks are on the Y Axis.
Changing your X Axis (Horizontal) Values
Let’s say to show a cleaner visual, we want to show the Week # instead of the date to show how it increases over the weeks.
We created another column to show what we want to replace the current X Axis with.
- Right click on the graph
- Click Select Data
3. Click on your Series
4. Select Edit
5. Delete the Formula in the box under the Series X Values.
6. Click on the Arrow next to the Series X Values Box. This will allow you to select the new X Values Series on the Excel Sheet
7. Highlight the new Series that you would like for the X Values. Select Enter.
Final Graph with Updated X Value Series in Excel
Now you’ll see the new value shows the week number instead of the date.
How to Change Horizontal Axis Values in Google Sheets
Starting with your Graph
Similar to what we did in Excel, we can do the same in Google Sheets. We’ll start with the date on the X Axis and show how to change those values.
- Right click on the graph
- Select Data Range
3. Click on the box under X-Axis
4. Click on the Box to Select a data range
5. Highlight the new range that you would like for the X Axis Series. Click OK
Final Graph with Updated X Value Series in Google Sheets
