Manage chart axis and number

Manage Chart Axis and Number

When you summarize data in a chart, Excel adds markers and labels to the horizontal and vertical axes of the chart to help viewers interpret the chart’s contents

Hide values on the horizontal axis

1.   Select a chart

2.   From the Ribbon, click Chart Layout tab go to Axes, click Axes button, select Horizontal Axis and select No Axis



Unhide values on the horizontal axis

1.   Select a chart

2.   From the Ribbon, click Chart Layout tab, go to Axes group, click Axes button select Horizontal Axis and Axis Left to Right

Change the labels on the vertical axis

1.   Select a chart

2.   From the Ribbon, click Chart Layout tab, go to Axes group and click Axes button then Vertical Axis and Axis Options…



3.   In the Format Axis dialog box, select Scale and use the tool to change the display of the vertical axis