When you create an Excel chart, both horizontal and vertical axes don’t have titles. In this tutorial, we will learn how to insert axis titles and labels in Excel.
Obviously, you can name axes in charts that include them already. For example, pie or doughnut charts have no X or Y axis, so they can’t be named.
Method 1- Add Axis Title by The Add Chart Element Option
As soon as you click on the chart area, two extra tabs appear on the ribbon related to the chart; the Design and the Format tabs.
To add the axes titles for your chart, follow these steps:
- Click on the chart area.
- Go to the Design tab from the ribbon.
- Click on the Add Chart Element option from the Chart Layout group.
- Select the Axis Titles from the menu.
- Select the Primary Vertical to add labels to the vertical axis, and Select the Primary Horizontal to add labels to the horizontal axis.
Method 2- Add Axis Title by The Chart Element Button
Excel 2013 and later versions provide a useful cross-cut, which is shown by a plus element.
Use this button to add titles to your chart axes:
- Click on the chart area.
- Click on the Chart Element button (according to the picture 2.)
- Check the Axes Titles from the checklist (if you need to add a label to one of the axes, click on the little arrows in front of the Axes Titles checkbox and check the Primary Vertical or the primary Horizontal checkboxes.)
- Enter the axis title.
Link to the Text Instead of Retype
Let’s see how to link the chart axis name to the text we already mentioned in a workbook.
- Add Title one of your chart axes according to Method 1 or Method 2.
- Select the Axis Title. (picture 6)
- Click in the Formula Bar and enter =.
- Select the cell that shows the axis label. (in this example we select X-axis)
- Press Enter.
Video 1- Link the chart axis name to the text
You can connect with us and ask our experts for your inquiries and get more Excel Support Services.
Reduce costs, accelerate tasks, and improve quality with Excel Automation Services.