How to Create Stock Chart in Excel

In this Excel charting tutorial you will learn how to make a stock chart in Excel. You can use such a graph everytime you have open, high, low, close data values.

Stock data preparation

When creating a stock chart, it is important to have a data that looks like this:

stock chart data table

Note: Depending on the kind of stock chart, you could rather label the data with high, low, and closing price, or volume traded, high, low, and closing price. You could also use volume, open, high, low, and the closing.

1. Mark just the open, high, low and close columns (1), and click on Quick analysis (2).

stock chart mark few columns

Inserting a stock chart 

2. Click charts (1), and then press More (2).

stock chart more charts

3. Click all charts (1), stock (2), choose chart (3), and press ok (4).

choose stock chart

4. Right click on legends (1), and click select data (2).

stock chart select data

5. Click edit on horizontal.

stock chart edit horizontal

6. Choose stock's names and press ok.

stock name

7. Press ok.

stock chart click ok

In the end, we would have created a chart that looks like this:

Stock Chart Excel

Here you can download free template of Stock Chart.

Further reading:
How to monitor stock prices in Excel
How to calculate stock beta in Excel