How does an Excel line chart set the axis starting point to not be 0?

An Excel line chart marks a data point, setting the starting point of the axis to 0 the data points of the default line chart are not marked and can be marked with a data marker with a simple setting. The default starting point for the axis is 0. You can also change the value of the axis starting point with a simple setting

1, as shown in the figure has a data source table has two rows of data composition Select the area through the Menu Bar Chart Wizard to generate a line chart directly click to complete it

2, this is the generated line chart containing two series can observe the axis starting point of the 00 percent line data points are not marked

3. The axis format can be set to 20 under the minimum value of the Tick tab by double-clicking the axis.

4, the point is determined after viewing the effect of the coordinates of the starting point has become 20

5. Double-click the top line to bring up the Data Series Format dialog box check the value of the tab on the data label so you can mark the data point.

6, click OK after the observation of the above discounted data points have been the corresponding value tag, but the location of the mark and the polyline overlap

7, double-click any data points to bring up the Data Marker Format dialog box in the Alignment tab position on the top of the selection so you can put the data points of data markers above the polyline

8, click OK to use the same method for the following line lines to do the same operation the final effect of the axis from the 20 start data points on the data marker