Stock Chart in Excel

Excel Stock Chart

Stock chart in excel is also known as high low close chart in excel because it used to represent the conditions of data in markets such as stocks, the data is the changes in the prices of the stocks, we can insert it from insert tab and also there are actually four types of stock charts, high low close is the most used one as it has three series of price high end and low, we can use up to six series of prices in stock charts.

How to Create Stock Charts in Excel? (Step by Step)

In order to create this chart, we need to have proper data on stock prices on daily-wise. We need to have an opening price, a high price in the day, a low price in the day, and what is the close price in the day. So for our demonstration purpose, I have created the below data of stock prices.

Stock Chart in Excel Example
You can download this Stock Chart Excel Template here – Stock Chart Excel Template

Follow the below steps to create your first Stock Chart.

  1. Select the data in the worksheet.


    Step 2

  2. Go to INSERT > Stock Chart > Open-High-Low-Close.

    Stock Chart in Excel Step 0.3.1.1

  3. Now, we will have a chat like below.

    Step 0.4

  4. Select the vertical axis and press Ctrl + 1.

    Stock Chart in Excel Step 0.5

  5. In the format data series box, make minimum as 50 and Maximum as 65. Major to 1.

     Step 6

  6. Now enlarge the chart vertically and horizontally. We will have a chart below.

    Stock Chart in Excel Step 0.7

In this chart, we can see for each date. We have the box with upward and downward arrows. Upward and downward arrows represent opening and closing stock prices for each date, but we don’t know exactly which is opening and which is closing stock price. The reason why we cannot say which is opening and which is closing because there are situations where an opening is more and closing is less and vice-versa.

So, how do we identify which is the opening price and which is the closing price?

Some boxes have filled color, and some don’t. In order to identify which is open and which is close, we need to rely on these boxes.

“If the box is non-filled, then the opening price is a downward arrow,” i.e., the stock is profitable for the day.

“If the box is filled, then the upward arrow is the opening price,” i.e., the stock is under loss for that day.

The continuous line of an upward arrow indicates the high price for the day, and the continuous line of a downward arrow indicates the low price for the day.

Like this using Stock Chart, we can analyze the charts and make some interpretations. We have four kinds of stock charts available with excel, below are types.

“High – Low – Close,” “Open – High – Low – Close,” “Volume – High – Low – Close,” and “Volume – Open – High – Low – Close.”

Based on the structure of the data, we can choose the appropriate one to show the numbers in the graph.

Recommended Articles

This has been a guide to Stock Chart in Excel. Here we learn how to create a stock chart in excel with an example and downloadable excel template. You can learn more about excel functions from the following articles –

  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>