How to change horizontal axis value in Excel
![](https://spreadcheaters.com/wp-content/uploads/Dataset-How-to-change-horizontal-axis-value-in-Excel-1024x432.png)
![](https://spreadcheaters.com/wp-content/uploads/Final-Image-How-to-change-horizontal-axis-value-in-Excel.gif)
While excel has a lot of cool features for charts and graphs, sometimes we may need to change axis values after the chart has been created. Let’s see how we can do that.
Step 1 – Select Data button
![](https://spreadcheaters.com/wp-content/uploads/Step-1-How-to-change-horizontal-axis-value-in-Excel.png)
– Click the chart. The Chart Tools will appear in the ribbon.
– Click the Chart Design tab.
– In the Data group click the Select Data button.
Step 2 – Select Data Source dialog
![](https://spreadcheaters.com/wp-content/uploads/Step-2-How-to-change-horizontal-axis-value-in-Excel.gif)
– On clicking the Select Data button the Select Data Source dialog box will appear on screen.
– Under the Horizontal (Category) Axis Labels click Edit.
– Axis Labels dialog will appear.
– Under the Axis labels range:, click the textbox labeled Select Range.
– Click and drag to select the Dealer ID values from cells A2 to A11.
– Click OK and then OK again.
– The horizontal axis values have been changed.