How to change values in excel chart

About the Author Shawn McClain has spent over 15 years as a journalist covering technology, business, culture and the arts.

how to change values in excel chart

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.

How to Format the X and Y Axis Values on Charts in Excel 2013

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.

how to change values in excel chart

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.

Q. How do I change the numbers in my Excel chart?

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.

how to change values in excel chart

Katie Hutchison. Like Us! To make chart data easier to understand, you can also change the way they look.

how to change values in excel chart

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.

how to change values in excel chart