How do you label axes in excel

Chapter 3: How to add axis titles. Chapter 4: Editing the Axis Titles. Chapter 5: Wrapping things up…. Before you start: Throughout this guide, you need a data set to practice. Download it right below! Obviously, you can name axes in charts that include them already. 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.

Excel and later versions provide a useful cross-cut, which is shown by a plus element. 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. Your email address will not be published. Save my name, email, and website in this browser for the next time I comment. If you want to add vertical axis label, please click Primary Vertical Axis Title under the Axis Title drop down, and choose one format of the title you like, then enter the label text.

See screenshots:. Click to select the chart that you want to insert axis label. Then click the Charts Elements button located the upper-right corner of the chart. In the expanded menu, check Axis Titles option, see screenshot:. And both the horizontal and vertical axis text boxes have been added to the chart, then click each of the axis text boxes and enter your own axis labels for X axis and Y axis separately.

Related articles:. How to add comment to chart in Excel? If you haven't yet created the document, open Excel and click Blank workbook , then create your graph before continuing. It's to the right of the top-right corner of the graph. This will open a drop-down menu. Click the Axis Titles checkbox. It's near the top of the drop-down menu. Doing so checks the Axis Titles box and places text boxes next to the vertical axis and below the horizontal axis.

If there is already a check in the Axis Titles box, uncheck and then re-check the box to force the axes' text boxes to appear. Select an "Axis Title" box. Click either of the "Axis Title" boxes to place your mouse cursor in it. Enter a title for the axis. Select the "Axis Title" text, type in a new label for the axis, and then click the graph. This will save your title. You can repeat this process for the other axis title.

You need to use macros for this. Go to Settings and add the Developer tab. Then enable the file as macro-enabled. This will allow you to right-click onto edit mode; from here you can add words on any amount of lines you need.

Not Helpful 1 Helpful 4.