How To Change Y Axis Scale In Excel

By default, Microsoft Office Excel determines the minimum and maximum scale values of the vertical (value) axis, also known as the y axis, when you create a chart. However, you tin can customize the scale to improve come across your needs. When the values that are plotted in the chart encompass a very large range, yous tin as well change the value centrality to a logarithmic scale, also known as log scale.

To change the calibration of other axes in a chart, come across Modify the scale of the horizontal (category) axis in a chart or Alter the scale of the depth (serial) axis in a nautical chart.

1. In a chart, click the value axis that yous want to alter, or do the following to select the axis from a listing of chart elements:

   1. Click anywhere in the chart.

      This displays the Nautical chart Tools, adding the Design and Format tabs.

   2. On the Format tab, in the Current Option grouping, click the arrow side by side to the Chart Elements box, and so click Vertical (Value) Axis.

      

2. On the Format tab, in the Current Choice group, click Format Selection.

3. In the Format Axis dialog box, click Centrality Options, and then do one or more than of the following:

   Important    The post-obit scaling options are bachelor merely 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 option, type a different number in the Minimum box or the Maximum box. You tin can click Reset 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 Pocket-size unit option, blazon a dissimilar number in the Major unit of measurement box or Minor unit box. You can click Reset to bring it back to its original value if needed.

   3. To contrary the order of the values, select the Values in reverse order 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 bottom to the peak of the nautical chart. Likewise, when you lot change the gild 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 centrality to logarithmic, select the Logarithmic scale check box.

      Note    A logarithmic scale cannot be used for negative values or aught.

   5. To change the brandish units on the value axis, in the Display units listing, select the units you desire.

      To prove a characterization that describes the units, select the Testify brandish units characterization on chart check box.

      Tip    Changing the display unit of measurement is useful when the chart values are large numbers that you desire to announced shorter and more than readable on the axis. For example, you can display chart values that range from 1,000,000 to 50,000,000 equally 1 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, under Tick Marks, select whatsoever of the options in the Major type or Pocket-size type boxes.

   7. Click the drop down box under Labels and choose a label position.

   8. To change the point where you want the horizontal (category) axis to cantankerous the vertical (value) axis, nether Floor crosses at, click Axis value, and then type the number you want in the text box. Or, click Maximum centrality value to specify that the horizontal (category) axis crosses the vertical (value) centrality at the highest value on the centrality.

      Note    When yous click Maximum centrality value, the category labels are moved to the opposite side of the chart.

   

1. In a chart, click the value axis that y'all desire to change, or do the following to select the axis from a listing of chart elements:

   1. Click anywhere in the nautical chart.

      This displays the Chart Tools, calculation the Design, Layout, and Format tabs.

   2. On the Format tab, in the Current Selection group, click the arrow next to the Chart Elements box, and then click Vertical (Value) Axis.

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:

   Important    The post-obit scaling options are available only when a value centrality 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 and then type a different number in the Minimum box or the Maximum box.

   2. To alter the interval of tick marks and nautical chart gridlines, for the Major unit or Minor unit option, click Stock-still, and so blazon a different number in the Major unit of measurement box or Minor unit of measurement box.

   3. To reverse the gild of the values, select the Values in reverse lodge check box.

      Notation    When you change the gild of the values on the vertical (value) axis from bottom to elevation, the category labels on the horizontal (category) axis flip from the bottom to the peak of the chart. Likewise, when you lot change the guild of the categories from left to right, the value labels flip from the left side to the right side of the nautical 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 zilch.

   5. To alter the brandish units on the value axis, in the Display units listing, select the units you lot want.

      To evidence a label that describes the units, select the Show display 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 announced shorter and more readable on the centrality. For case, you can display chart values that range from 1,000,000 to l,000,000 as 1 to fifty on the centrality and testify a label that indicates the units are expressed in millions.

   6. To alter the placement of the axis tick marks and labels, select any of the options in the Major tick mark type, Pocket-size tick mark type, and Axis labels boxes.

   7. To change the indicate where you want the horizontal (category) centrality to cross the vertical (value) axis, under Horizontal axis crosses, click Centrality value, and then blazon the number you desire 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 click Maximum axis value, the category labels are moved to the reverse side of the chart.

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

1. This step applies to Discussion 2016 for Mac only: On the View carte, click Print Layout.

2. Click the chart.

3. On the Format tab, click Vertical (Value) Centrality in the dropdown list and and then click Format Pane.

4. In the Format Axis dialog box, click Axis Options, and so do ane or more of the following:

   Important    The following scaling options are available merely 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 choice, type a dissimilar number in the Minimum box or the Maximum box. Yous tin click the Reset pointer to bring it 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 selection, type a different number in the Major unit box or Pocket-size unit box. You tin 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 reverse social club cheque box.

      Note    When you change the order of the values on the vertical (value) centrality from lesser to top, the category labels on the horizontal (category) centrality flip from the bottom to the elevation of the chart. Likewise, when you change the order of the categories from left to correct, 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 check box.

      Notation    A logarithmic scale cannot exist used for negative values or zero.

   5. To change the display units on the value axis, in the Display units list, select the units you desire.

      To show a label that describes the units, select the Testify display units label on nautical chart check box.

      Tip    Changing the display unit of measurement is useful when the chart values are large numbers that you want to appear shorter and more readable on the axis. For instance, yous tin can brandish chart values that range from 1,000,000 to l,000,000 as ane to l on the axis and prove 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-size type boxes.

   7. Click the drop downward box under Labels and choose a label position.

   8. To change the point where yous desire the horizontal (category) axis to cross the vertical (value) axis, under Floor crosses at, click Axis value, and so type the number you desire 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 lot click Maximum axis value, the category labels are moved to the opposite side of the chart.

   

1. This step applies to Word for Mac 2011 only: On the View card, click Print Layout.

2. Click the nautical chart, and then click the Chart Layout tab.

3. Under Axes, click Axes > Vertical Axis > Centrality Options.

   

   Annotation:Depending on the nautical chart blazon, some options may not exist available.

4. In the Format Centrality dialog box, click Scale, and under Value axis scale, modify any of the following options:

   • To change the number at which the vertical (value) axis starts or ends, for the Minimum or Maximum pick, blazon a unlike number in the Minimum box or the Maximum box.

   • To change the interval of tick marks and chart gridlines, for the Major unit or Small unit option, type a different number in the Major unit box or Small unit of measurement box.

5. Click OK.

Add or change the position of vertical centrality characterization

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

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

1. This pace applies to Word for Mac 2011 only: On the View menu, click Print Layout.

2. Click the nautical chart, and so click the Nautical chart Layout tab.

3. Under Axes, click Axes > Vertical Centrality, and so click the kind of axis label that you desire.

   

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

Tips

• When a chart displays a secondary vertical (value) centrality, yous tin also change the scale of that axis. For more information nearly displaying a secondary vertical axis, encounter Add or remove a secondary axis in a chart.

• XY (besprinkle) charts and bubble charts show values on both the horizontal (category) axis and vertical (value) centrality, while line charts show values on just the vertical (value) axis. This deviation is important in determining which chart type to use. Considering the scale of the line chart'south horizontal (category) axis cannot exist inverse equally much equally the scale of the vertical (value) axis that is used in the xy (besprinkle) chart, consider using an xy (scatter) nautical chart instead of a line chart if you have to change the scaling of that axis, or brandish information technology as a logarithmic scale.

• Afterward changing the scale of the centrality, you lot might also want to change how the axis is formatted. For more data, run into 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: grimexpearre.blogspot.com

Share this post