Learn how to show or hide chart axes in Excel

For most chart types, the vertical axis (known as the value or y-axis) and horizontal axis (known as the category or x-axis) are displayed automatically when you create a chart in Excel. However, it is not necessary to display all or some axes for a graph.

The instructions in this article apply to Excel 2019, 2016, 2013, 2010; Excel for Office 365 and Excel for Mac.

Content
  1. What is an axis?
  2. 3D axes
  3. Horizontal axis
  4. Vertical axis
  5. Secondary vertical axis
  6. axis titles
  7. Graphs without axes
  8. Hide and show graph axes

What is an axis?

An axis on a chart or graph in Excel or Google Sheets is a horizontal or vertical line of units of measurement. The axes define the plot area of ​​bar charts, bar charts, line charts, and other charts. The axis displays the units of measure and provides the coordinate system for the data displayed on the map. Most charts, such as bar and line charts, have two axes used to measure and categorize data:

  • Vertical axis: Y axis or meaning .

  • Horizontal axis: X axis or category .

3D axes

In addition to the horizontal and vertical axes, 3D charts have a third axis. z-axis, also called the z-axis secondary vertical axis or as depths displays data along the third dimension (depth) of the chart.

Horizontal axis

The horizontal x-axis is at the bottom of the plot area and contains category titles taken from the data in the worksheet.

Vertical axis

The vertical Y-axis is on the left side of the plot area. The scale for this axis is usually based on the data values ​​being plotted.

Secondary vertical axis

The second vertical axis, located on the right side of the chart, displays two or more types of data in one chart. It is also used to represent data values.

climate map of climatographer is an example of a combination graph that uses a second vertical axis to display temperature and precipitation data over time in a single graph.

axis titles

All map axes are identified by an axis title that contains the units displayed on the axes.

Graphs without axes

Bubble, radar, and pie charts are some chart types that don’t use axes to represent data.

Hide and show graph axes

To hide one or more axes in an Excel chart:

  1. Select an empty map area to show the right side of the map Charting Tools .

  2. Select Chart Elements plus sign ( + ) to open the menu Chart Elements .

  3. Uncheck to hide all axes shafts .

  4. To hide one or more axes, move the mouse cursor over axes to display a right arrow.

  5. Click on the arrow to display a list of axes that can be shown or hidden on the map.

  6. Disable the axes you want to hide.

  7. Check the boxes for the axes you want to display.

Leave a Reply

Your email address will not be published.