How to Create Stock Charts in Excel

You can create a stock chart from spreadsheet data in Excel.

Stock charts display share prices, volume and trends. Microsoft Excel has several built-in charts that you can use to create a stock chart based on a spreadsheet of data. However, to take full advantage of the stock chart feature, make sure you use the predetermined ordering for market data. Organize the stock's data into the spreadsheet by setting each stock's name in the first column, followed by the opening high, low and closing value of the shares in the following columns.

Instructions

1. Highlight the data you want to be displayed on a stock chart in the spreadsheet. Make sure the data is formatted and structured properly.

2. Open the "Insert" menu located on the top of the Microsoft Excel application.

3. Select "Chart."

4. Select "Stock" from the Chart Type section in the Chart Dialog box.

5. Select the type of the stock chart in the "Chart sub-type" section you want. You can preview the resulting stock chart by pressing the "Press and Hold to View Sample" button.

6. Click "Next."

7. Click "Finish" to create your stock chart.

References

• Microsoft: Creating A Stock Chart