About the Author Shawn McClain has spent over 15 years as a journalist covering technology, business, culture and the arts.
Change the alignment and orientation of labels Office 2010. To change the number at which the value axis starts or ends, type a different number in the Minimum box or the Maximum box.
Yes No. Change the scale of the vertical value axis in a chart. Change the label text in the chart In the chart, click the horizontal axis, or do the following to select the axis from a list of chart elements: To change the number formatting for all values on the selected axis, click the Number option. You can, however, customize the scale to better meet your needs.
This effectively moves the category labels to the opposite side of the chart. The geographic regions will be uniformly spaced because they are text instead of values that can be measured.
To show a label that describes the units, select the Show display units label on chart check box. For more info on what axes are and what you can do with them, see All about axes. Other chart types, such as column, line, and area charts, show numeric values on the vertical value axis only and show textual groupings or categories on the horizontal axis.How To Change The Scale On An Excel Chart (Super Quick!)
For example, you can display chart values that range from 1,000,000 to 50,000,000 as 1 to 50 on the axis and show a label that indicates the units are expressed in millions. In the Format Axis dialog box, click Axis Options , and then do one or more of the following: When a chart displays a secondary vertical value axis, you can also change the scale of that axis.
Katie Hutchison. Like Us! To make chart data easier to understand, you can also change the way they look.
Under Text layout , do one or more of the following: Charts typically have two axes that are used to measure and categorize data: Both of these items have numeric values, and the data points will be plotted on the x and y axes relative to their numeric values. However, you still can by simply clicking Edit Legend Series and choosing X values.