What if the Excel line vertical axis value is inconsistent with the actual value?

Source: Internet
Author: User

Excel line Vertical axis values are inconsistent with the actual values what to do? When you make an Excel chart line chart, you sometimes find that the ordinate axis is inconsistent with the actual raw data, and the vertical axis is much larger than the actual value. This example describes the causes of this phenomenon and how to solve the problem.

1. First look at the example, the maximum value in the original data is 7, but the maximum value of the vertical axis is 20.

2, do the right mouse button in the chart, select "Change chart type".

3, we hover the mouse over the current chart type button, you will see the current chart is "with data markers stacked line chart." This stacked graph adds values together, resulting in a graph reaction that is inconsistent with the actual value.

4, we choose the normal "with data marker line chart" and determine.

5, at this point, and then look at the chart, the vertical axis and the actual line chart displayed in the data label is the same.

6, the same, do column chart when it may also appear this problem, do not choose "stacked map" on it.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

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.