How to add a polyline to a Excel2010 stock chart

Arranges the data in the order you specify, where you need to place the turnover column between the open and Date columns, as shown in the figure.

　　Operation Steps

[1] Select a cell in the stock price data, select Insert → other chart → stock chart, where you select the fourth sub chart type "Volume-opening-high-low-close chart".

Get the following chart:

[2] Select the change hand Rate series, click Change Chart type in the chart tools-Design tab, and then determine after you select Line chart in the Change Chart Type dialog box. Finally, adjust the legend to the bottom of the chart as needed.