How To Change Chart Range In Excel

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

To change the scale of other axes in a nautical chart, run into Change the scale of the horizontal (category) axis in a chart or Change the calibration of the depth (serial) centrality in a chart.

In a chart, click the value centrality that yous desire to change, or do the following to select the axis from a list of nautical 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 arrow next to the Chart Elements box, and and so click Vertical (Value) Axis.
On the Format tab, in the Current Selection grouping, click Format Pick.
In the Format Axis dialog box, click Axis Options, so do ane or more of the following:

Important The following scaling options are available just when a value axis is selected.
1. To modify 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. Y'all can click Reset to bring it dorsum 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, blazon a dissimilar number in the Major unit of measurement box or Pocket-sized unit box. You tin can click Reset to bring it back to its original value if needed.
3. To reverse the social club of the values, select the Values in reverse order bank check box.
  
  Note When you 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 top of the chart. As well, when y'all 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 scale cannot exist used for negative values or zero.
5. To change the brandish units on the value axis, in the Display units list, select the units you lot want.
  
  To show a characterization that describes the units, select the Testify display units label on chart check box.
  
  Tip Changing the display unit is useful when the chart values are large numbers that y'all want to appear shorter and more than readable on the axis. For example, you tin can display chart values that range from 1,000,000 to fifty,000,000 as 1 to fifty on the axis and show a label that indicates the units are expressed in millions.
6. To change the placement of the centrality tick marks and labels, nether Tick Marks, select any of the options in the Major blazon or Pocket-size blazon boxes.
7. Click the drop downwardly box under Labels and choose a characterization position.
8. To change the bespeak where you desire the horizontal (category) axis to cross the vertical (value) axis, under Floor crosses at, click Axis value, and then blazon the number y'all 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 yous click Maximum axis value, the category labels are moved to the opposite side of the nautical chart.

In a chart, click the value axis that you want to modify, or exercise the following to select the axis from a list 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 Nautical chart Elements box, so click Vertical (Value) Centrality.
On the Format tab, in the Current Selection group, click Format Selection.
In the Format Centrality dialog box, click Axis Options, and then practise i or more of the following:

Of import The following scaling options are available 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, click Fixed, and and then blazon 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 of measurement or Minor unit pick, click Fixed, and then type a different number in the Major unit of measurement box or Small-scale unit box.
3. To reverse the order of the values, select the Values in reverse society bank check box.
  
  Note When you change the order of the values on the vertical (value) axis from bottom to tiptop, the category labels on the horizontal (category) axis flip from the bottom to the pinnacle of the chart. Likewise, when yous change the lodge 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 centrality to logarithmic, select the Logarithmic calibration check box.
  
  Annotation A logarithmic scale cannot exist used for negative values or zero.
5. To change the brandish 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 Show display units characterization on chart bank 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 axis. For example, you can brandish chart values that range from 1,000,000 to 50,000,000 every bit i to 50 on the axis and testify a label that indicates the units are expressed in millions.
6. To change the placement of the axis tick marks and labels, select any of the options in the Major tick mark type, Modest tick marker type, and Axis labels boxes.
7. To alter the point where you want the horizontal (category) axis to cross the vertical (value) axis, under Horizontal axis crosses, click Axis value, and and then 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) 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.

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

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

Important The following scaling options are available but 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 unlike 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 of measurement or Pocket-sized unit option, blazon a different number in the Major unit box or Minor unit box. You can click the Reset pointer to bring it dorsum to its original value if needed.
3. To opposite the order of the values, select the Values in reverse order check box.
  
  Note When you lot change the order of the values on the vertical (value) axis from bottom to superlative, the category labels on the horizontal (category) centrality flip from the bottom 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 right side of the chart.
4. To alter the value centrality to logarithmic, select the Logarithmic scale check box.
  
  Note A logarithmic scale cannot be 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 lot desire.
  
  To testify a label that describes the units, select the Show display units label on chart check box.
  
  Tip Irresolute 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, yous tin can display chart values that range from one,000,000 to 50,000,000 equally 1 to fifty on the axis and testify a characterization 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 Small-scale type boxes.
7. Click the driblet downwardly box under Labels and choose a label position.
8. To change the point where you want the horizontal (category) axis to cross 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) axis at the highest value on the axis.
  
  Note When you lot 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 carte du jour, click Print Layout.
Click the chart, and so click the Chart Layout tab.
Under Axes, click Axes > Vertical Axis > Axis Options.

Note:Depending on the chart type, some options may non be available.
In the Format Axis dialog box, click Scale, and under Value axis scale, modify any 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 or Minor unit option, type a different number in the Major unit box or Modest unit box.
Click OK.

Add or change the position of vertical axis characterization

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

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

This footstep applies to Give-and-take for Mac 2011 simply: On the View carte, click Print Layout.
Click the chart, and then click the Chart Layout tab.
Under Axes, click Axes > Vertical Axis, and and then click the kind of axis label that you lot desire.

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

Tips

When a chart displays a secondary vertical (value) axis, you can as well change the scale of that axis. For more information about displaying a secondary vertical axis, encounter Add or remove a secondary axis in a chart.
XY (besprinkle) charts and bubble charts prove values on both the horizontal (category) axis and vertical (value) centrality, while line charts show values on merely the vertical (value) axis. This difference is important in determining which nautical chart type to employ. Considering the scale of the line chart'southward horizontal (category) axis cannot be changed as much as the scale of the vertical (value) axis that is used in the xy (scatter) chart, consider using an xy (scatter) nautical chart instead of a line chart if you take to modify the scaling of that axis, or display it equally a logarithmic scale.
After changing the calibration of the axis, yous might also desire to modify how the axis is formatted. For more information, see Alter the display of nautical chart axes.