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

Your data should include the stock’s name, date, and the stock prices. Organize your data with the following columns: “Date”, “Open”, “High”, “Low”, and “Close”.

stock chart data table

Note: The specific columns you need may vary based on the type of stock chart you plan to create. Common data arrangements include high, low, and closing price, or volume traded, high, low, and closing price. Another option is to include volume, open, high, low, and closing price.

Highlight the “Open”, “High”, “Low”, and “Close” columns, then click on ‘Quick Analysis’.

stock chart mark few columns

Inserting a stock chart

Click charts, and then press More.

stock chart more charts

Select the type of stock chart you want to create.

choose stock chart

Right-click on legends, and click select data.

stock chart select data

Click edit on horizontal.

stock chart edit horizontal

Choose stock’s names.

stock name

Press ok.

stock chart click ok

The chart will be inserted into your worksheet.

Stock Chart Excel

You can format the chart to your liking by adding a title, changing the axis labels, or adjusting the colors.

Here you can download free template of Stock Chart.

See also  How to Make a Kite Chart in Excel