How To Add Horizontal Values In Excel
How to Change Horizontal Axis Values – Excel & Google Sheets
This tutorial will demonstrate how to modify Horizontal Axis Values in Excel and Google Sheets
How to Change Horizontal Axis Values in Excel
Starting with your Graph
In this tutorial, nosotros'll showtime with a Scatterplot that is showing how many clicks a website gets per week.
Every bit you can meet, our date is on the X Centrality and Clicks are on the Y Axis.
Irresolute your Ten Centrality (Horizontal) Values
Let'southward say to testify 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 nosotros want to replace the current Ten Axis with.
- Right click on the graph
- Click Select Data
iii. Click on your Series
4. Select Edit
5. Delete the Formula in the box under the Serial Ten Values.
6. Click on the Arrow next to the Serial X Values Box. This will allow yous to select the new X Values Series on the Excel Canvass
7. Highlight the new Serial that you lot would like for the X Values. Select Enter.
Final Graph with Updated Ten Value Series in Excel
Now yous'll see the new value shows the week number instead of the engagement.
How to Change Horizontal Axis Values in Google Sheets
Starting with your Graph
Similar to what nosotros did in Excel, nosotros tin do the same in Google Sheets. We'll start with the date on the 10 Axis and show how to change those values.
- Right click on the graph
- Select Information Range
3. Click on the box nether X-Axis
4. Click on the Box to Select a data range
5. Highlight the new range that you would like for the X Centrality Series. Click OK
Last Graph with Updated X Value Serial in Google Sheets
How To Add Horizontal Values In Excel,
Source: https://www.automateexcel.com/charts/horizontal-values/
Posted by: yuenbegamseley.blogspot.com
0 Response to "How To Add Horizontal Values In Excel"
Post a Comment