How Excel draws a beautiful line chart

How Excel draws a beautiful line chart

To say a joke: Zhuge Liang once had such an exclamation: "Pro table Shong, unintelligible," meaning is holding an Excel chart, because can not understand this chart to express what meaning, can't help but the tears cry.

First of all, the operation is not complicated, but the steps are more, please do psychological preparation in advance.

Look at the data source:

Production process:

Click the data region to insert a column chart.

Click the grid line and press the DELETE key to remove it. Click the transaction size data series, design change chart type, and select a line chart with data markers.

Double-click the Chain Growth data series (where it is close to the horizontal axis) and set to the secondary axis: