Anyone who knows anything about Microsoft Excel knows that one of the many, many features the premiere spreadsheet program for the Windows Operating System has to offer is the ability to create and have charts in an Excel worksheet. There are an array of different kinds of charts you can create on Microsoft Excel (from pie charts and doughnut charts to scatter charts of graphs and bar charts). To make a chart easier to read and understand, Microsoft Excel allows users to add titles to the axes of the chart.

Obviously, this feature is only available for charts that actually have axes in the first place, meaning that charts such as pie charts and doughnut charts can't really have axis labels. In addition, some charts that have axes (such as radar charts) don't really have the capability to display axis titles so this feature also doesn't apply to them.

Axis labels are also available for all of the axes a chart has, which means that you can even have a label for the depth axis in 3D charts and and labels for the secondary horizontal and secondary vertical axes for charts that have them. Excel also allows users to link the label they create for an axis to be linked to corresponding text in a worksheet's cells by simply creating a reference to those specific cells.

Adding labels to the axes of a chart is a pretty simple and straightforward process regardless of what version of Microsoft Excel you are using. However, it should be noted that adding labels to the axes of charts works a bit differently in Microsoft Excel 2013 and 2016 than it did in Microsoft Excel 2007 and 2010.

To add axis labels in Microsoft Excel 2007 and 2010

To add labels to the axes of a chart in Microsoft Excel 2007 or 2010, you need to:

  1. Click anywhere on the chart you want to add axis labels to. Doing so will cause a group of tabs titledChart Toolsto appear in Excel's toolbar with theDesign,LayoutandFormattabs residing within it.
  2. Navigate to theLayouttab in Microsoft Excel's toolbar.
  3. In theLabelssection, click onAxis Titles.
  4. If you would like to label the primary horizontal axis (primary x axis) of the chart, click onPrimary Horizontal Axis Titleand then click on the option that you want. If the chart has a secondary horizontal axis (secondary x axis) that you would like to label, you can click onSecondary Horizontal Axis Titleand then click on the option that you want. If you would like to label the primary vertical axis (primary y axis) of the chart, click onPrimary Vertical Axis Titleand then click on the option that you want. If the chart has a secondary vertical axis (seconday y axis) that you would like to label, you can click onSecondary Vertical Axis Titleand then click on the option that you want. If you want to label the depth (series) axis (the z axis) of a chart, simply click onDepth Axis Title and then click on the option that you want.
  5. In theAxis Titletext box that appears within the chart, type the label you want the selected axis to have. PressingEnter within theAxis Titletext box starts a new line within the text box.

To add axis labels in Microsoft Word 2013 and 2016

If you would like to add labels to the axes of a chart in Microsoft Excel 2013 or 2016, you need to:

  1. Click anywhere on the chart you want to add axis labels to.
  2. Click on theChart Elementsbutton (represented by a green+ sign) next to the upper-right corner of the selected chart.
  3. Enable Axis Titlesby checking the checkbox located directly beside theAxis Titlesoption. Once you do so, Excel will add labels for the primary horizontal and primary vertical axes to the chart. Note: If your chart has a depth axis (an axis only 3D charts have), a secondary horizontal axis or a secondary vertical axis, click on the arrow next to theAxis Titlesoption and click onMore Options… and thenenablelabels for the depth, secondary horizontal or secondary vertical axes on the chart.
  4. One by one, click on each of theAxis Titletext boxes that appear within the chart and type in the labels for each of the chart's axes. To start a new line within theAxis Title text boxes, simply pressShift+Enter and a line break will be inserted.

Photo of Kevin Arrows

Kevin is a dynamic and self-motivated information technology professional, with a Thorough knowledge of all facets pertaining to network infrastructure design, implementation and administration. Superior record of delivering simultaneous large-scale mission critical projects on time and under budget.