This how we change the X-axis values in Excel.Ĭhanging Intervals to Change X-Axis Values in Excel Finally exiting the panel, we can see our bar chart having data of only Odd serial number months like below.After all of the above steps are done, we can exit the Select Data Source panel by pressing OK.Read More: How to Change Axis Labels in Excel (3 Easy Methods) So we need to deselect the Even numbers from the list like in the image below. For our case, we need to show only the Odd serial number’s data. To modify data or filter data according to our need, we can select or deselect which data to show on the plot from the Horizontal (Category) Axis Labels option. Step 3: Modify Data for Changing X-Axis Values in Excel Read More: How to Add Secondary X Axis in Excel (with Quick Steps) After pressing OK we can see the horizontal axis data has been replaced in the Select Data Source panel like this.On a separate column type the month’s respective numbers serially and select the data like below image.A data selection box called Axis Labels will appear.At first, on the Select Data Source panel, click on the Edit.

To select new data and replace old data, we need to follow these steps: Step 2: Selection of New Data to Change X-Axis Values After clicking on Select Data, the Select Data Source dialogue box will appear.First, select the X-axis of the bar chart and right click on it.To start changing the X-axis value in Excel, we need to first open the data editing panel named Select Data Source.

To do so we need to follow these steps below. Now we want to replace the Month by the serial number of respective months and see the chart only for Odd serial numbers. For example, here is a dataset with the Profit of a company separated by Months that we will use to change X-axis values in Excel.Īnd here is the respective bar chart of the dataset above. You can see how much each category is worth on the vertical axis. Step-by-Step Procedures to Change X-Axis Values in ExcelĪny Excel plot has separate data on the X-axis or horizontal axis.

Excel graph axis label month