Excel Stock Chart

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

To create this chart, we need to have correct data on stock prices daily. We need to have an opening price, a high price during the day, a low price during the day, and what is a close price during the day. So for our demonstration purpose, we have created the below data of stock prices.

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

  • Select the data in the worksheet. Go to INSERT> Stock Chart > Open-High-Low-Close. Now, we will have a chat like the one below. Select the vertical axis and press Ctrl + 1 keys. In the format data series box, make “Minimum” as 50 and “Maximum” 65, and “Major” 1. Now, enlarge the chart vertically and horizontally. We will have a chart below.

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

Some boxes have filled colors, and some do not. We must rely on these boxes to identify which are open and which are close.

If the box is non-filled, 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.

Using the stock chart, we can analyze the charts and make some interpretations. We have four stock charts available in Excel, below are the 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 article is a guide to the 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: –

  • What are Control Charts in Excel?What Are Control Charts In Excel?The control chart analyses how data changes over time in business statistics, allowing users to see how any process changes. Its components are the control line, as well as the upper and lower control lines, which are formed using the data’s average and standard deviation.read moreStacked Bar Chart in ExcelStacked Bar Chart In ExcelThe stacked bar chart in Excel represents data in the shape of bars, with the bars representing different segments or categories for comparison. A stacked bar chart is used to compare different types of data in terms of their values.read moreCreate a Tornado Chart in ExcelCreate A Tornado Chart In ExcelIn Excel, a tornado chart is a bar chart that compares data across different types of data or categories. The horizontal bars in the tornado chart are meant to highlight the impact, such as how a condition will impact the outcome.read moreTypes of Pie Chart in ExcelTypes Of Pie Chart In ExcelMaking a pie chart in excel can help you with the pictorial representation of your data and simplifies the analysis process. There are multiple kinds of pie chart options available on excel to serve the varying user needs.read moreScientific Notation in ExcelScientific Notation In ExcelIn Excel, scientific notation is a specific style of writing numbers in scientific and exponential forms. Scientific notation compactly helps display values, allowing us to compare and use the same in calculations.read more