The table contains the basic information collected from the stock trading software. The picture shows the basic data of a stock on the 7th, such as trading volume, opening and closing.

Select data such as opening, high, low and close, and then click the recommended chart option in Insert. I. e. in that ord marked in the figure.

Click "All Charts" and select "Stock Price Chart". As shown in the figure.

Wait until the k-line diagram is as shown in the figure.

Select the data in the Volume column, and then select Recommended Chart in Insert. As shown in the figure.

Get the final renderings.