To change the point where you want the vertical (value) axis to cross the horizontal (category) axis, expand Axis Options, and then under Vertical axis crosses, select At category number and type the number that you want in the text box, or select At maxi

Change Horizontal Axis Values in Excel 2016 Often there is a need to change the data labels in your Excel 2016 graph. The procedure is a little different from the previous versions of Excel 2016.

How to Change Horizontal Axis Values. In the example we have a chart with Years on x-axis and Sales values on the y-axis: Figure 1. How to change x axis values. To change x axis values to “ Store” we should follow several steps: Right-click on the gra