How To Label Axis On Excel Mac 2016

Download Article

Download Article

This wikiHow teaches you lot how to place labels on the vertical and horizontal axes of a graph in Microsoft Excel. You can exercise this on both Windows and Mac.

Steps Download Article

1. 1

   Open your Excel certificate. Double-click an Excel document that contains a graph.

   • If you lot haven't yet created the certificate, open Excel and click Bare workbook, then create your graph earlier continuing.

2. 2

   Select the graph. Click your graph to select information technology.

   Advertising

3. 3

   Click + . Information technology's to the right of the acme-right corner of the graph. This will open a driblet-downward card.

4. 4

   Click the Axis Titles checkbox. It's well-nigh the top of the drop-down carte. Doing then checks the Axis Titles box and places text boxes adjacent to the vertical centrality and below the horizontal axis.

   • If there is already a cheque in the Axis Titles box, uncheck so re-check the box to forcefulness the axes' text boxes to appear.

5. 5

   Select an "Axis Championship" box. Click either of the "Axis Title" boxes to place your mouse cursor in it.

6. 6

   Enter a title for the axis. Select the "Centrality Title" text, type in a new label for the centrality, and so click the graph. This will save your championship.

   • You tin repeat this process for the other centrality championship.

   Ad

Add New Question

• Question

  How exercise I put words of axes labels on 2 or 3 lines?

  

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

Ask a Question

200 characters left

Include your email address to get a message when this question is answered.

Submit

Advertisement

• The steps for labeling axes in this article tin besides use to charts y'all create in Microsoft Word, PowerPoint, and Outlook.

• Edit the labels of your axes at any fourth dimension by clicking straight on the labels. A cursor will announced, and you'll accept the ability to enter the desired text.

Advertisement

• If you switch your nautical chart type to a blazon that does non back up axis labels such as a pie chart, your axis labels volition disappear. However, your axis labels will reappear if you switch dorsum to the original chart blazon.

Advertizement

Virtually This Article

Article Summary 10

1. Open an Excel document.
2. Click the graph.
three. Click +
4. Click Axis Titles
v. Click an "Axis Title" text box.
6. Type in the label you'd like the axis to have.

Did this summary help yous?

Thank you to all authors for creating a page that has been read 352,978 times.

Is this commodity upward to appointment?

Source: https://www.wikihow.com/Label-Axes-in-Excel

Posted by: claytongeoppons.blogspot.com

Share this post