How To Add Axis Labels In Excel Charts
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.
![How to use the Add Chart Element to add axis title.](https://bsuite365.com/wp-content/uploads/2020/05/add-axis-title-1024x512.png)
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.Â
![The Chart Element button in Excel.](https://bsuite365.com/wp-content/uploads/2020/05/the-chart-element-button-1024x512.png)
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.
Enhance your software capabilities with our customizable Add-In Solutions, seamlessly integrating new features to meet your business needs.
![Use the Chart Element button to add axis title.](https://bsuite365.com/wp-content/uploads/2020/05/add-axis-title-method-2-1024x512.png)
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)
![Selecting the axis title for linking to the text.](https://bsuite365.com/wp-content/uploads/2020/05/select-the-axis-title-1024x512.png)
- Click in the Formula Bar and enter =.
- Select the cell that shows the axis label. (in this example we select X-axis)
- Press Enter.
Enhance your business efficiency with our specialized Macro Development Services, tailored to automate and streamline your operations for maximum productivity
![How to link the X axis title to the text in Excel?](https://bsuite365.com/wp-content/uploads/2020/05/link-the-axis-name-to-the-text-1024x512.png)
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.
Our experts will be glad to help you, If this article didn't answer your questions.
We believe this content can enhance our services. Yet, it's awaiting comprehensive review. Your suggestions for improvement are invaluable. Kindly report any issue or suggestion using the "Report an issue" button below. We value your input.