28th November 2019

office
14

How do I change the vertical axis value in Excel?

  1. In a chart, click the value axis that you want to change, or do the following to select the axis from a list of chart elements:
  2. On the Format tab, in the Current Selection group, click Format Selection.
  3. In the Format Axis dialog box, click Axis Options, and then do one or more of the following:

In respect to this, how do you change the horizontal axis in Excel?

Click on the "Layout" tab at the top of the Excel window, then click the drop-down arrow on the left side of the ribbon and choose "Horizontal (Category) Axis" from the list of options. Click the "Format Selection" button next to the drop-down arrow to continue. The Format Axis window appears.

How do you add axis labels in Excel 2016?

Add axis titles manually
  1. Click anywhere in the chart to which you want to add axis titles.
  2. On the Layout tab, in the Labels group, click Axis Titles.
  3. Do any of the following:
  4. In the Axis Title text box that appears in the chart, type the text that you want.
  5. To format the text in the title box, do the following:
Write Your Answer

Rate

86% people found this answer useful, click to cast your vote.

4.3 / 5 based on 3 votes.

Bookmark

Press Ctrl + D to add this site to your favorites!

Share