How To Change Vertical Scale In Excel

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

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

In a chart, click the value axis that you want to change, or do the post-obit to select the centrality from a listing of chart elements:
1. Click anywhere in the chart.
  
  This displays the Chart Tools, calculation the Design and Format tabs.
2. On the Format tab, in the Current Selection group, click the pointer next to the Chart Elements box, and so click Vertical (Value) Centrality.
On the Format tab, in the Current Selection group, click Format Selection.
In the Format Axis dialog box, click Axis Options, and then do ane 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 tin click Reset to bring information technology back to its original value if needed.
2. To change the interval of tick marks and nautical chart gridlines, for the Major unit or Minor unit choice, type a different number in the Major unit box or Minor unit box. You can click Reset to bring it dorsum to its original value if needed.
3. To reverse the society of the values, select the Values in opposite order check box.
  
  Note When you change the club of the values on the vertical (value) axis from bottom to acme, the category labels on the horizontal (category) axis flip from the lesser to the top of the chart. Likewise, when yous change the lodge 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 centrality to logarithmic, select the Logarithmic calibration check box.
  
  Annotation A logarithmic scale cannot be used for negative values or zero.
5. To alter the display units on the value axis, in the Display units list, select the units you desire.
  
  To testify a label that describes the units, select the Bear witness display units characterization on nautical chart check box.
  
  Tip Changing the brandish unit is useful when the chart values are large numbers that you desire to appear shorter and more readable on the axis. For example, you tin can display chart values that range from 1,000,000 to 50,000,000 as 1 to fifty on the axis and testify a label that indicates the units are expressed in millions.
6. To alter the placement of the axis tick marks and labels, under Tick Marks, select whatsoever of the options in the Major type or Small type boxes.
7. Click the drop downward box under Labels and choose a label position.
8. To change the betoken where you want the horizontal (category) axis to cantankerous the vertical (value) axis, under Floor crosses at, click Axis value, and and so type the number y'all want in the text box. Or, click Maximum centrality value to specify that the horizontal (category) centrality crosses the vertical (value) centrality 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 nautical chart.

In a nautical chart, click the value axis that you want to change, or practise the following to select the axis from a list of chart elements:
1. Click anywhere in the chart.
  
  This displays the Chart Tools, adding the Design, Layout, and Format tabs.
2. On the Format tab, in the Electric current Selection grouping, click the arrow next to the Chart Elements box, and so click Vertical (Value) Axis.
On the Format tab, in the Current Pick group, click Format Choice.
In the Format Axis dialog box, click Axis Options, and so practice ane or more of the post-obit:

Important The following scaling options are available only when a value axis is selected.
1. To change the number at which the vertical (value) centrality starts or ends, for the Minimum or Maximum option, click Fixed, and and then type a dissimilar number in the Minimum box or the Maximum box.
2. To change the interval of tick marks and nautical chart gridlines, for the Major unit or Minor unit of measurement option, click Fixed, and then type a different number in the Major unit box or Minor unit box.
3. To contrary the order of the values, select the Values in reverse order check box.
  
  Note When you lot alter 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 acme of the chart. Too, 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 calibration bank check box.
  
  Annotation A logarithmic calibration cannot be used for negative values or nothing.
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 Show brandish units label on nautical chart check box.
  
  Tip Changing the display unit is useful when the chart values are big numbers that yous want to appear shorter and more readable on the axis. For example, y'all tin display chart values that range from 1,000,000 to 50,000,000 as 1 to fifty 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, select whatever of the options in the Major tick mark blazon, Minor tick marking type, and Axis labels boxes.
7. To change the betoken where you desire the horizontal (category) centrality to cross the vertical (value) axis, nether Horizontal axis crosses, click Axis value, and so blazon the number you want 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.
  
  Note When you click Maximum axis value, the category labels are moved to the opposite side of the chart.

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

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

Important The following scaling options are bachelor just when a value axis is selected.
1. To change the number at which the vertical (value) centrality starts or ends, for the Minimum or Maximum option, type a different number in the Minimum box or the Maximum box. You 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, blazon a unlike number in the Major unit box or Pocket-sized unit box. You can click the Reset arrow to bring it dorsum to its original value if needed.
3. To reverse the order of the values, select the Values in reverse social club cheque box.
  
  Note When you modify the society 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 top of the chart. Likewise, when yous alter 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 scale cannot be used for negative values or zero.
5. To alter the display units on the value centrality, in the Display units list, select the units you want.
  
  To show a label that describes the units, select the Prove brandish units characterization on chart check box.
  
  Tip Changing the display unit is useful when the nautical chart values are big numbers that you lot want to appear shorter and more readable on the axis. For case, you can display chart values that range from 1,000,000 to 50,000,000 as one to 50 on the centrality and bear witness 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 any of the options in the Major type or Pocket-sized type boxes.
7. Click the drib downwards box under Labels and choose a label position.
8. To modify the point where y'all want the horizontal (category) axis to cantankerous the vertical (value) axis, under Floor crosses at, click Axis value, and then type the number you 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.
  
  Note When you click Maximum axis value, the category labels are moved to the contrary side of the chart.

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

Note:Depending on the chart blazon, some options may not be bachelor.
In the Format Axis dialog box, click Calibration, and under Value axis scale, alter any of the following options:
- To change the number at which the vertical (value) axis starts or ends, for the Minimum or Maximum option, blazon a unlike number in the Minimum box or the Maximum box.
- To alter the interval of tick marks and chart gridlines, for the Major unit or Pocket-size unit option, type a different number in the Major unit box or Minor unit box.
Click OK.

Add together or change the position of vertical axis characterization

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

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

This step applies to Give-and-take for Mac 2011 just: On the View bill of fare, click Print Layout.
Click the nautical chart, and then click the Chart Layout tab.
Under Axes, click Axes > Vertical Centrality, and so click the kind of axis label that you want.

Note:Depending on the nautical chart blazon, some options may non be available.

Tips

When a chart displays a secondary vertical (value) axis, you can also alter the scale of that centrality. For more information about displaying a secondary vertical centrality, see Add or remove a secondary axis in a chart.
XY (scatter) charts and bubble charts show values on both the horizontal (category) axis and vertical (value) centrality, while line charts show values on only the vertical (value) axis. This deviation is important in determining which chart type to utilise. Because the scale of the line nautical chart's horizontal (category) axis cannot be changed as much as the calibration of the vertical (value) axis that is used in the xy (scatter) chart, consider using an xy (scatter) nautical chart instead of a line nautical chart if you have to alter the scaling of that axis, or display it as a logarithmic scale.
After changing the calibration of the centrality, you lot might also want to alter how the centrality is formatted. For more data, see Change the display of chart axes.

Source: https://support.microsoft.com/en-us/office/change-the-scale-of-the-vertical-value-axis-in-a-chart-05973661-e56a-4486-a9f3-f9ce41df0021

Posted by: hancockhitylo.blogspot.com