How to Create a Stock Chart (Open-High-Low-Close) in Excel


This post will guide you how to create a stock chart to present your stock’s data in an easy to read manner in your current worksheet in Excel. How do I create a High-Low-Close Stock market chart based on your stock data in Excel 2013/2016.

1. Create High-Low-Close Stock Chart

If you want to create a high-low-close chart, your data need to contain open price, high price, low price, close price and date. It can be used to show the daily high price, low price, and closing prices for a stock over a given period of time. Data can be similar with the below shown:

create stock chart 1

Then you can create the High-Low-Close Stock chart with the following steps:

Step1: select your source data.

create stock chart 1

Step2: go to Insert tab in the Excel Ribbon, and click Other charts or Insert Waterfall, Funnel, Stock, Surface, or Radar Chart command under Charts group. And select Open-High-Low-Close in the Stock section from the dropdown list box.

create stock chart 2
create stock chart 3

Step3: Stock chart will be created as below:

create stock chart 4

2. Video: Create High-Low-Close Stock Chart

In this video, we’re diving into the fascinating world of creating stock charts, specifically Open-High-Low-Close (OHLC) charts, right in Excel.

Leave a Reply