Why is the starting point of an Excel line chart not 0?

Source: Internet
Author: User
1. As shown in the following figure, a data source table consists of two rows of data. Select this area and use the menu bar chart wizard to generate a line chart and click finish.
2. This is the generated line chart containing two series. We can see that the starting point of the axis is 0. The data points on the line are not marked.
3. You can double-click the axis to bring up the axis format. Set it to 20 at the minimum value of the scale tab.
4. Click OK to check that the starting point of the effect coordinate has changed to 20.
5. Double-click the line above to bring up the data series format dialog box and select a value on the data tab to mark the data points.
6. Click "OK" and check that the discounted data point on the top has been marked by the corresponding value, but some of the marked positions overlap with the line.
7. Double-click any data point to bring up the data mark Format dialog box and select the top of the alignment tab to place the data mark of the data point above the line
8. Click "OK" and use the same method to perform the same operation for the line series below. The final effect is as follows: data mark appears on the data point starting from 20 on the axis.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.