How To Change Horizontal Axis Values In Excel 2016

Change Horizontal Axis Values in Excel 2016

Oft there is a demand to modify the information labels in your Excel 2016 graph. The procedure is a little dissimilar from the previous versions of Excel 2016. You volition add corresponding data in the same table to create the label. You can also create a new prepare of data to populate the labels. Exist more efficent and achieve more with Excel Beginner to Advance Form up to 90% discount from this link.

1. Select the Chart that you have created and navigate to the Centrality yous want to change.

ii. Right-click the axis you want to change and navigate to Select Information and the Select Data Source window will pop upward, click Edit

3. The Edit Series window will open up, then you tin can select a series of data that y'all would similar to change.

four. Click Ok

For a time series like months, when you lot click select data you will not have the selection to directly edit the 10-centrality. Withal, you still can past simply clicking Edit Fable Serial and choosing X values. Yet, if you graph is chronological or time serial based you need to option a complementary chronological data. For categorical data, y'all don't need to worry most this. Also, you can direct change x values from Select Data Source window. But essentially the steps are the same.
Follow the visuals instructions below or sentinel the video:

Create a graph. From the image below, yous can see that this graph is based on the index column and the Selected Catamenia column. Our goal is to supersede the X axis with data from Date Cavalcade.

Ediit the Axey to change the axis labels

Correct-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

In one case you cull Select Data, an Edit Serial window will open with information on the centrality.
You can select any new data to populate the labels
Our goal is to change the x-axis and so that y'all can delete the x values and supersede them with the new values. If you accept chronological data, you lot can direct access the labels.