Moving The Axis On Excel How To Make Labels

You want one set of values to be on the X-axis, but its still on the Y-axis, even if you click Design Data Switch RowColumn.

Moving The Axis On Excel How To Make Labels

Read Next How to Change X Axis Values in Excel How To Make Labels and Sub-Labels in Gmail How to Create a Database on Microsoft Excel How to Split Cells in Microsoft Excel Kevin Arrows Network Team LeadManager (LANWAN) Twitter 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.

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 cant really have axis labels.

In addition, some charts that have axes (such as radar charts) dont really have the capability to display axis titles so this feature also doesnt 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 worksheets 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.

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: Click anywhere on the chart you want to add axis labels to.

Doing so will cause a group of tabs titled Chart Tools to appear in Excels toolbar with the Design, Layout and Format tabs residing within it.

If you would like to label the primary horizontal axis (primary x axis) of the chart, click on Primary Horizontal Axis Title and 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 on Secondary Horizontal Axis Title and 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 on Primary Vertical Axis Title and 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 on Secondary Vertical Axis Title and 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 on Depth Axis Title and then click on the option that you want.

In the Axis Title text box that appears within the chart, type the label you want the selected axis to have.

Pressing Enter within the Axis Title text 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: Click anywhere on the chart you want to add axis labels to.

Click on the Chart Elements button (represented by a green sign) next to the upper-right corner of the selected chart.

Enable Axis Titles by checking the checkbox located directly beside the Axis Titles option.

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 the Axis Titles option and click on More Options and then enable labels for the depth, secondary horizontal or secondary vertical axes on the chart.

One by one, click on each of the Axis Title text boxes that appear within the chart and type in the labels for each of the charts axes.

To start a new line within the Axis Title text boxes, simply press Shift Enter and a line break will be inserted.

Moving The Axis On Excel For Mac