"Go" Excel do horizontal and unequal scatter plots or line charts

Transfer from http://blog.sina.com.cn/s/blog_70e287ea01018v4f.html

Horizontal or vertical line chart is not commonly used in China, but foreign articles can often be seen. But the specific mapping method asked a lot of seniors and classmates have no accurate answer, either the language is unknown, or inconsistent with the requirements.

Not much nonsense said, a few days ago, sister sent over a data as follows table and diagram:

This is a very simple drawing, but there is no classmate found its horizontal front four points are equidistant, but the back of the 3h and 4h unequal distance. According to the simple method, the slope of 3h and 4h can be significantly increased. And that does not necessarily match the facts. You can try it out for yourself, and combine the graphic contrast effect behind the author.

After many groping and query finally found one of the simple method.

First, the results are as follows

Then select the data in the table, as follows (this article is based on office2007)

Be as

It can be seen that the points in the back of the 3h and 4h have been separated, but not properly wired. The focus is on the solution below, right-click on the diagram to select "Select data." Send back to appear as

Click on the bottom left corner: "Hidden cells and empty cells", select "link data points with straight lines", click OK.

The following diagram is completed.

From the results can be known. According to the original cartographic 3h point, the large slope rises. But it is plotted from the improved unequal distance coordinates. There has been a noticeable change. Only 4h points rise.

"Go" Excel do horizontal and unequal scatter plots or line charts