How to hide or show chart axis in Excel?

Maybe in some cases, you will want to hide the chart axis in Excel. This tutorial will tell you how to hide or show chart axis in Excel.

Hide or show chart axis in Excel

Hide or show chart axis with VBA

Hide or show chart axis in Excel

In Excel 2007/2010

1. Click the chart to show Chart Tools in the Ribbon, then click Layout > Axes. See screenshot:

2. In Axes list, select the axis you want to hide, and then click None. See screenshot:

Then the axis will be hidden.

In Excel 2013

1. Click the chart to show Chart Tools in the Ribbon, then click Design > Add Chart Element. See screenshot:

2. In the list, click Axes, and then select the axis you want to hide.

Then the axis will be hidden.

Remove chart axis with VBA

If you are interested in VBA code, you can use the follow code to remove the axis.

1. Select a chart and hold on Alt + F11 keys to open Microsoft Visual Basic for Applications window.

2. Then click Insert > Module to insert a Module window, and then copy the following VBA into it.

VBA: Remove X axis from chart.

Sub XLabelHidden()
'Updateby20140911
Dim xChart As Chart
Dim xChartArea As ChartArea
If VBA.TypeName(Application.Selection) = "ChartArea" Then
    Set xChartArea = Application.Selection
    Set xChart = xChartArea.Parent
    With xChart.Axes(XlAxisType.xlCategory).TickLabels.Font
        .ColorIndex = 2
        .Background = xlTransparent
    End With
End If
End Sub

3. Click Run or press F5 to run the code. Then the selected chart’s X axis is removed.

Note: This VBA code only works on removing X axis, and the removed axis cannot be shown again.