How To Change The Horizontal Axis In Excel

Change Horizontal Axis Values in Excel 2016

Oftentimes there is a need to change the data labels in your Excel 2016 graph. The procedure is a footling different from the previous versions of Excel 2016. Yous will add corresponding information in the aforementioned table to create the label. You tin can as well create a new set of data to populate the labels. Exist more than efficent and accomplish more with Excel Beginner to Advance Form up to 90% discount from this link.

1. Select the Nautical chart that you lot take created and navigate to the Axis you desire to modify.

2. Correct-click the axis you want to alter and navigate to Select Data and the Select Data Source window will pop upwardly, click Edit

3. The Edit Series window will open up, so you can select a series of data that yous would like to change.

4. Click Ok

For a time series like months, when you click select data y'all volition not have the option to directly edit the x-axis. However, you however tin by simply clicking Edit Legend Series and choosing X values. However, if you graph is chronological or time series based yous need to pick a complementary chronological data. For categorical data, you don't need to worry about this. Besides, you can directly change 10 values from Select Data Source window. Just essentially the steps are the same.
Follow the visuals instructions below or watch the video:

Create a graph. From the image below, you tin can see that this graph is based on the index column and the Selected Period column. Our goal is to replace the 10 axis with information from Appointment Column.

Ediit the Axey to change the axis labels

Right-click the graph to options to format the graph. In the options window, navigate to Select Data to change the label axis data.
Right click and add new data to change labels on the graph

Once you choose Select Information, an Edit Serial window volition open with information on the centrality.
You can select any new data to populate the labels
Our goal is to modify the x-centrality and so that you can delete the x values and supercede them with the new values. If you have chronological data, you can directly admission the labels.