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, the 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.
Follow the below steps to create your first Stock Chart.
- Step 1: Select the data in the worksheet.
- Step 2: Go to INSERT > Stock Chart > Open-High-Low-Close.
- Step 3: Now we will have chat like the below.
- Step 4: Select the vertical axis and press Ctrl + 1.
- Step 5: In the format data series box make minimum as 50 and Maximum as 65. Major to 1.
- Step 6: Now enlarge the chart vertically and horizontally. We will have a chart below.
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 downward arrow” i.e. stock is profitable for the day.
“If the box is filled then the upward arrow is opening price” i.e. stock is under loss for that day.
The continuous line of an upward arrow indicates the high price for the day and the continued 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.
This has been a guide to Stock Chart in Excel. Here we learn how to create a stock chart in excel with example and downloadable excel template. You can learn more about excel functions from the following articles –