How To Change The Values On The Y Axis In Excel

Past default, Microsoft Office Excel determines the minimum and maximum scale values of the vertical (value) axis, besides known every bit the y centrality, when you create a chart. However, yous can customize the scale to better meet your needs. When the values that are plotted in the chart cover a very large range, you tin can also change the value centrality to a logarithmic scale, also known every bit log scale.

To modify the calibration of other axes in a chart, see Change the calibration of the horizontal (category) centrality in a chart or Change the scale of the depth (series) centrality in a chart.

In a chart, click the value axis that you want to change, or do the following to select the centrality from a list of chart elements:
1. Click anywhere in the chart.
  
  This displays the Chart Tools, adding the Design and Format tabs.
2. On the Format tab, in the Current Selection group, click the arrow side by side to the Nautical chart Elements box, and so click Vertical (Value) Centrality.
On the Format tab, in the Electric current Selection grouping, click Format Selection.
In the Format Centrality dialog box, click Centrality Options, and then do one or more than of the post-obit:

Of import The following scaling options are bachelor only when a value axis is selected.
1. To modify the number at which the vertical (value) axis starts or ends, for the Minimum or Maximum choice, type a unlike number in the Minimum box or the Maximum box. You tin click Reset to bring it back to its original value if needed.
2. To modify the interval of tick marks and chart gridlines, for the Major unit or Minor unit option, type a different number in the Major unit box or Small unit of measurement box. You tin can click Reset to bring it back to its original value if needed.
3. To reverse the order of the values, select the Values in opposite guild bank check box.
  
  Note When you modify the order of the values on the vertical (value) axis from bottom to top, the category labels on the horizontal (category) axis flip from the lesser to the top of the chart. Likewise, when you change the order of the categories from left to right, the value labels flip from the left side to the right side of the chart.
4. To change the value axis to logarithmic, select the Logarithmic scale check box.
  
  Note A logarithmic calibration cannot be used for negative values or zip.
5. To change the display units on the value axis, in the Display units list, select the units you want.
  
  To testify a label that describes the units, select the Show brandish units label on chart check box.
  
  Tip Changing the display unit is useful when the nautical chart values are large numbers that you want to appear shorter and more than readable on the axis. For example, yous can display chart values that range from 1,000,000 to fifty,000,000 equally one to 50 on the axis and show a label that indicates the units are expressed in millions.
6. To modify the placement of the axis tick marks and labels, nether Tick Marks, select whatever of the options in the Major type or Minor type boxes.
7. Click the drib downward box under Labels and choose a label position.
8. To change the point where you desire the horizontal (category) axis to cross the vertical (value) axis, nether Floor crosses at, click Axis value, so type the number yous want in the text box. Or, click Maximum axis value to specify that the horizontal (category) axis crosses the vertical (value) axis at the highest value on the axis.
  
  Annotation When you lot click Maximum axis value, the category labels are moved to the opposite side of the chart.

In a chart, click the value centrality that you want to modify, or exercise the following to select the axis from a list of nautical chart elements:
1. Click anywhere in the chart.
  
  This displays the Nautical chart Tools, calculation the Blueprint, Layout, and Format tabs.
2. On the Format tab, in the Current Selection grouping, click the arrow adjacent to the Nautical chart Elements box, and then click Vertical (Value) Axis.
On the Format tab, in the Current Pick grouping, click Format Selection.
In the Format Axis dialog box, click Axis Options, so practice one or more of the following:

Important The post-obit scaling options are available simply when a value axis is selected.
1. To change the number at which the vertical (value) axis starts or ends, for the Minimum or Maximum option, click Fixed, and then type a different number in the Minimum box or the Maximum box.
2. To change the interval of tick marks and chart gridlines, for the Major unit or Pocket-sized unit of measurement pick, click Stock-still, and then type a different number in the Major unit box or Small-scale unit of measurement box.
3. To opposite the social club of the values, select the Values in reverse order check box.
  
  Note When yous alter the order of the values on the vertical (value) centrality from bottom to meridian, the category labels on the horizontal (category) axis flip from the lesser to the top of the chart. Likewise, when you alter the order of the categories from left to right, the value labels flip from the left side to the correct side of the chart.
4. To change the value axis to logarithmic, select the Logarithmic scale check box.
  
  Note A logarithmic scale cannot exist used for negative values or null.
5. To change the display units on the value axis, in the Display units listing, select the units you want.
  
  To show a label that describes the units, select the Bear witness brandish units label on chart check box.
  
  Tip Changing the brandish unit of measurement is useful when the chart values are large numbers that y'all want to announced shorter and more readable on the axis. For example, yous can display chart values that range from 1,000,000 to 50,000,000 as i to 50 on the axis and show a label that indicates the units are expressed in millions.
6. To alter the placement of the axis tick marks and labels, select whatsoever of the options in the Major tick mark type, Minor tick marking type, and Axis labels boxes.
7. To change the point where yous want the horizontal (category) axis to cantankerous the vertical (value) axis, under Horizontal axis crosses, click Axis value, and so type the number you lot want in the text box. Or, click Maximum axis value to specify that the horizontal (category) centrality crosses the vertical (value) axis at the highest value on the centrality.
  
  Annotation When you click Maximum axis value, the category labels are moved to the contrary side of the chart.

Note:The screen shots in this commodity were taken in Excel 2016. If you lot have a different version your view might be slightly different, but unless otherwise noted, the functionality is the same.

This step applies to Word 2016 for Mac but: On the View menu, click Print Layout.
Click the chart.
On the Format tab, click Vertical (Value) Axis in the dropdown list and and then click Format Pane.
In the Format Axis dialog box, click Centrality Options, and then exercise one or more of the following:

Important The post-obit scaling options are bachelor only when a value axis is selected.
1. To change the number at which the vertical (value) axis starts or ends, for the Minimum or Maximum option, type a different number in the Minimum box or the Maximum box. You lot can click the Reset arrow to bring it back to its original value if needed.
2. To change the interval of tick marks and chart gridlines, for the Major unit or Minor unit option, type a different number in the Major unit box or Pocket-sized unit box. You can click the Reset arrow to bring it back to its original value if needed.
3. To reverse the guild of the values, select the Values in opposite gild cheque box.
  
  Note When y'all modify the order of the values on the vertical (value) axis from bottom to top, the category labels on the horizontal (category) axis flip from the bottom to the superlative of the chart. Besides, when you modify the club of the categories from left to right, the value labels flip from the left side to the right side of the chart.
4. To alter the value axis to logarithmic, select the Logarithmic scale check box.
  
  Annotation A logarithmic scale cannot be used for negative values or aught.
5. To change the display units on the value axis, in the Display units list, select the units you lot want.
  
  To show a label that describes the units, select the Show display units characterization on chart check box.
  
  Tip Changing the display unit is useful when the chart values are large numbers that you want to announced shorter and more readable on the centrality. For example, you lot can brandish chart values that range from 1,000,000 to l,000,000 as 1 to 50 on the axis and show a label that indicates the units are expressed in millions.
6. To change the placement of the axis tick marks and labels, under Tick Marks, select whatsoever of the options in the Major type or Minor type boxes.
7. Click the drop downwardly box under Labels and choose a characterization position.
8. To change the point where you want the horizontal (category) axis to cantankerous the vertical (value) axis, under Floor crosses at, click Axis value, and so type the number yous desire in the text box. Or, click Maximum axis value to specify that the horizontal (category) axis crosses the vertical (value) centrality at the highest value on the axis.
  
  Notation When you click Maximum axis value, the category labels are moved to the opposite side of the chart.

This step applies to Word for Mac 2011 only: On the View bill of fare, click Print Layout.
Click the chart, and and so click the Chart Layout tab.
Under Axes, click Axes > Vertical Axis > Axis Options.

Notation:Depending on the chart type, some options may not be available.
In the Format Axis dialog box, click Calibration, and under Value axis scale, change whatever of the post-obit options:
- To change the number at which the vertical (value) axis starts or ends, for the Minimum or Maximum option, type a different number in the Minimum box or the Maximum box.
- To change the interval of tick marks and chart gridlines, for the Major unit of measurement or Small unit option, type a different number in the Major unit of measurement box or Pocket-sized unit box.
Click OK.

Add together or alter the position of vertical axis label

For a vertical axis, you can add and position the centrality on the top or the bottom of the plot expanse.

Note:The options may be reversed for bar compared cavalcade charts.

This step applies to Word for Mac 2011 just: On the View menu, click Print Layout.
Click the chart, and and so click the Chart Layout tab.
Nether Axes, click Axes > Vertical Axis, and then click the kind of axis characterization that you want.

Note:Depending on the chart type, some options may not exist available.

Tips

When a chart displays a secondary vertical (value) axis, you tin also change the scale of that axis. For more information almost displaying a secondary vertical axis, see Add together or remove a secondary axis in a chart.
XY (scatter) charts and bubble charts evidence values on both the horizontal (category) centrality and vertical (value) axis, while line charts show values on but the vertical (value) axis. This divergence is important in determining which nautical chart type to use. Considering the scale of the line chart's horizontal (category) axis cannot be inverse equally much every bit the scale of the vertical (value) centrality that is used in the xy (scatter) chart, consider using an xy (besprinkle) chart instead of a line nautical chart if you accept to alter the scaling of that axis, or display it as a logarithmic scale.
After irresolute the scale of the centrality, you might also want to change how the centrality is formatted. For more than information, see Change the brandish of nautical chart axes.