how to plot a graph in excel with lines going through axis

For example, you can display chart values ranging from 1,000,000 to 50,000,000 as 1 to 50 on the axis and show a label that indicates that the units are expressed in millions. Tip If the chart values are large numbers, you can make the axis text shorter and more readable by changing the display unit of the axis. If you want to show a label that describes the units, select the Show display units label on chart check box.

To change the units displayed on the value axis, select the units that you want in the Display units list.

To change the interval of tick marks and chart gridlines, type a different number in the Major unit box or Minor unit box.To change the number at which the value axis starts or ends, type a different number in the Minimum box or the Maximum box.

The Scale tab provides different options for a category (x) axis. Important The following scaling options are only available when a value (y) axis is selected.

On the Scale tab, do one or more of the following:.

Note The Selected Axis command is only available when a chart axis is selected.

On the Format menu, click Selected Axis.

In a chart sheet or an embedded chart, click the value (y) axis that you want to change.

You can, however, customize the scale to better meet your needs.

By default, Microsoft Excel determines the minimum and maximum scale values of the value (y) axis in a chart.

How to plot a graph in excel with lines going through axis