Excel charts make it easier for you to understand business data and relationships by displaying information in a graphical format. Like many graphs, a chart may contain a vertical or horizontal axis that contains values. Excel sets these values when you create a chart, but
Excel charts make it easier for you to understand business data and relationships by displaying information in a graphical format. Like many graphs, a chart may contain a vertical or horizontal axis that contains values. Excel sets these values when you create a chart, but you are free to adjust the intervals between these values as well as the minimum and maximum values of the axis
Launch Excel and open a worksheet that has a chart whose tick mark intervals you’d like to change. Click the chart to display the Chart Tools section and then click the "Format" tab.
Click the arrow next to the Chart Elements drop-down box to view a list of chart elements. Click "Horizontal (Value) Axis" if you'd like to change the horizontal axis's intervals. Otherwise, click "Vertical (Category) Axis" to change the vertical axis's intervals. When you click one of those choices, Excel draws an outline around the axis you selected.
Click "Format" selection to open the Format Axis window and then click "Axis Options." The window's Minimum and Maximum text boxes show the axis' minimum and maximum values.
Find the Major Unit text box and