Question: How Do I Change The Horizontal Axis Labels In Excel 2016?

How do I change the horizontal axis values in Excel 2016?

In a chart, click the category axis that you want to change, or do the following to select the axis from a list of chart elements:Click anywhere in the chart.

On the Format tab, in the Current Selection group, click the arrow next to the Chart Elements box, and then click Horizontal (Category) Axis..

How do you move axis labels in Excel?

How to move Y axis to left/right/middle in Excel chart?Double click at the X axis (horizontal axis) to display the Format Axis pane. … If you are in Excel 2010 or 2007, it will open the Format Axis dialog.Then if you want to move the Y axis to the left, check Automatic in the Vertical axis crosses section.More items…

Why can’t I edit horizontal axis labels in Excel?

You can’t edit or type in the box, the axis labels are generated from the Excel sheet so you have to edit them there.

How do I change the horizontal axis labels in Excel?

Right-click the category labels you want to change, and click Select Data.In the Horizontal (Category) Axis Labels box, click Edit.In the Axis label range box, enter the labels you want to use, separated by commas.