![How How](/uploads/1/2/5/4/125445279/701153411.png)
Apr 12, 2014 - In Excel, we always create charts to make the data clear and visual. If you want to add vertical axis label, please click Primary Vertical Axis.
If you are using Excel 2010/2007, you can insert the axis label into the chart with following steps: 1. Select the chart that you want to add axis label.
![Vertical Vertical](https://erc.barnard.edu/sites/default/files/styles/wysiwyg_largest/public/screen_shot_2013-10-24_at_12.55.35_pm.png?itok=NjUw6J5j)
Navigate to Chart Tools Layout tab, and then click Axis Titles, see screenshot: 3. You can insert the horizontal axis label by clicking Primary Horizontal Axis Title under the Axis Title drop down, then click Title Below Axis, and a text box will appear at the bottom of the chart, then you can edit and input your title as following screenshots shown. 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: Add axis label to chart in Excel 2013 In Excel 2013, you should do as this: 1. 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: 3.
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. Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day! 300 New Features for Excel, Make Excel Much Easy and Powerful:. Merge Cell/Rows/Columns without Losing Data.
Combine and Consolidate Multiple Sheets and Workbooks. Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion.
Count by Colors, Paging Subtotals, Advanced Sort and Super Filter,. More Select/Insert/Delete/Text/Format/Link/Comment/Workbooks/Worksheets Tools.
Excel Online After you, you can add axis titles to the horizontal and vertical axes in charts that have axes. You can’t add them to charts that don’t have axes such as pie and doughnut charts. Much like a, axis titles help the people who view the chart understand what the data is about. Here’s how you add axis titles:.
Make sure you’re working in Excel Online edit mode. If you’re in view mode, click Edit Workbook Edit in Excel Online. Click anywhere in the chart to show the Chart Tools on the ribbon. Click Chart Axis Titles. Click Primary Horizontal Axis Title or Primary Vertical Axis Title. Do one of the following:. If you clicked Primary Horizontal Axis Title, pick Title Below Axis.
If you clicked Primary Vertical Axis Title, pick Rotated Title, Vertical Title, or Horizontal Title. In the Title text box, type a title for the axis.
To start a new line in the title, press Enter. Edit or remove axis titles You can change the axis titles or remove them from the chart. Click anywhere in the chart to show the Chart Tools. Click Chart Axis Titles Primary Horizontal Axis or Primary Vertical Axis Title. Do one of the following:. To change the title, click Edit Horizontal Axis Title or Edit Vertical Axis Title and edit the text in the Title text box. To remove the title, click None.