How To Change Axis Intervals In Excel

Change Horizontal Axis Values in Excel 2016

Frequently there is a need to alter the information labels in your Excel 2016 graph. The procedure is a little different from the previous versions of Excel 2016. You will add respective data in the same table to create the label. You can also create a new prepare of data to populate the labels. Be more efficent and reach more than with Excel Beginner to Accelerate Class upwards to 90% disbelieve from this link.

1. Select the Chart that you have created and navigate to the Axis you desire to alter.

2. Right-click the axis you want to modify and navigate to Select Data and the Select Data Source window will pop upwards, click Edit

iii. The Edit Series window will open up, then you can select a series of information that you would like to change.

4. Click Ok

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

Create a graph. From the image below, yous can see that this graph is based on the index cavalcade and the Selected Period column. Our goal is to supersede the X axis with information from Date 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 modify the label axis information.
Right click and add new data to change labels on the graph

Once you cull Select Information, an Edit Series window will open with data on the axis.
You can select any new data to populate the labels
Our goal is to change the x-axis so that y'all can delete the x values and replace them with the new values. If you accept chronological data, you lot can straight admission the labels.