Now to plot High-Low-Closing chart in excel, follow these steps. Column A contains dates, B contains high prices, C contains low prices and D contains Closing prices. Let's see an example of Excel High-Low-Closing chart to understand it. The length of line show the variation from closing value to low and high price. The line above the marker shows the high value and line below shows the low value. The values are represented using small lines with a dot/marker. The y-axis represents the values and x axis has time or any series name. This chart is used when we have Highest value, lowest value and the closing value. They are found under waterfall and stock chart category in charts group of insert menu.Įach stock chart type is used in a different scenario and they need different data arrangement. In excel, there are 4 types of Stock charts.
Basically, it can be used with any data that has high low values. As the name suggests, it is mainly used in the stock market to track the stocks of different companies or stock's high-low price on different dates/intervals. As the name suggests, Stock charts in excel is used to see high-low values of variables in a data set.
