Axis titles are a great way to add extra information to your Microsoft Excel charts. You can use them to show the relationships between different data points, or to identify specific groups of data. To add axis titles, follow these steps:

  1. Open Microsoft Excel and create a new spreadsheet.
  2. In the spreadsheet, click on the Chart Tools button.
  3. On the Chart Tools tab, click on the Add Axis button.
  4. In the Add Axis dialog box, enter values for each axis in the following fields: Data Type: text field, default is “Number” Data Range: text field, default is “0-9” Data Level: number field, default is 1 (lowest) The Data Level can be changed by clicking on the Change Value button and then selecting a different level from the drop-down list. The Data Range can be changed by clicking on the Edit Range button and then selecting a different range from the drop-down list. The Data Type can be changed by clicking on the Change Type button and then selecting a different type from the drop-down list. The Data Level can be changed by clicking on the Change Level button and then selecting a different level from the drop-down list. Click OK to close both dialog boxes and return to Excel’s main window. 5. To add data points to your chart, click on one of your data points in Excel’s main window and then click on another data point in your chart to select that point as an anchor point for that axis title (if there are no anchors). 6. To remove data points from your chart, click on one of your data points in Excel’s main window and thenclick on another data point in your chart to select that point as an anchor point for that axis title (if there are no anchors). 7. To change how axis titles are displayed in yourchart, click on one of your

There are plenty of ways to customize a chart you create in Excel. If you want to make sure your chart is clear to those viewing it, you can add vertical or horizontal axis titles and customize those too.

Add Axis Titles to a Chart in Excel

Select your chart and then head to the Chart Design tab that displays. Click the Add Chart Element drop-down arrow and move your cursor to Axis Titles. In the pop-out menu, select “Primary Horizontal,” “Primary Vertical,” or both.

If you’re using Excel on Windows, you can also use the Chart Elements icon on the right of the chart. Check the box for Axis Titles, click the arrow to the right, then check the boxes for the horizontal, vertical, or both titles.

When the axis title you select appears on the chart, it has a default name of Axis Title. Select the text box containing the default title and add your own.

RELATED: How to Create a Combo Chart in Excel

Customize the Axis Titles on a Chart

You can customize both the axis title boxes and the text within those boxes. And you have a few different ways to go about it.

First, right-click an axis title to display the floating toolbar. You’ll see options for Style, Fill, and Outline.

Use the drop-down arrows next to any of these options to apply a theme, use a gradient or texture, or choose a border style and color.

To take your customization a bit further, start by opening the Format Axis Title sidebar. You can either right-click a title and select “Format Axis Title” or double-click one of the titles.

At the top of the sidebar, make sure you see Title Options. Then use the three tabs directly below it for Fill & Line, Effects, and Size & Properties to make your adjustments.

You can do things like change the fill or border, add a shadow or glow, or adjust the alignment.

To customize the font, select Text Options at the top of the sidebar. Then use the tabs for Text Fill & Outline, Text Effects, and Text box.

You can then do things like change the font color or transparency, use a 3-D format, or change the text direction.

RELATED: How to Create a Geographical Map Chart in Microsoft Excel

Remove Axis Titles From a Chart

If you decide later to remove one or both axis titles, it’s just as easy as adding them.

Select the chart and go to the Chart Design tab. Click the Add Chart Element drop-down arrow, move your cursor to Axis Titles, and deselect “Primary Horizontal,” “Primary Vertical,” or both.

In Excel on Windows, you can also click the Chart Elements icon and uncheck the box for Axis Titles to remove them both. If you want to keep one title, use the arrow next to Axis Titles and mark the one you want.

If you’re looking for help with a particular graph, take a look at how to create and customize a waterfall chart or a funnel chart in Microsoft Excel.