Excel Stock Chart (Table of Contents)
Stock Chart in Excel
If you are a trader of the stock market then you must be already using the spreadsheet for your daily price tracking. Not many of us worried about the stock market at all because of the lack of knowledge in it. Just by looking at the data we don’t see much of the impact of stock prices on a daily basis. When it comes to stock market we can see four kinds of prices, first one is “Opening Price”, the second one is “High Price”, the third one is “Low Price” and fourth one is “Closing Price”.
If we can plot the graph for all these four numbers we can easily identify the impact of the stock price of different companies. In this article, we will show you how to create a stock chart with excel.
What are Stock Charts in Excel?
As the name itself says Stock Charts it shows the volatile prices of stock market prices of companies. Stock Chart doesn’t mean you can use it only for stock market volatility we can also use this for seasonal rail fall, temperature variations, etc
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.
With this data now we will build a stock chart in excel.
How to Create a Stock Chart in Excel?
Let’s see the example of a stock chart to understand it better.
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 like 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 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 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 –
- Marimekko Chart in Excel (Mekko)
- Control Charts in Excel
- Calculate Average with Multiple Criteria in Excel
- Use Excel as a Calculator
- 2D Stacked Bar Chart in Excel
- Create Tornado Chart in Excel
- Top 5 Types of Pie Chart in Excel
- Create Flow Chart in Excel
- 35+ Courses
- 120+ Hours of Videos
- Full Lifetime Access
- Certificate of Completion
- Basic Excel Training
- Advanced Excel Training
- Basic & Advanced VBA Course
- Excel Dashboard Course
- Data Analysis in Excel
- Create VBA Applications