In above chart, if we look at first point line on, shows the lowest price and highest price. Change the color of marker as suits you.Select the chart, goto design, choose an appropriate predefined design for your chart type. The default stock chart doesn't look that clear.And boom! You have your stock chart ready.

Goto insert=> Charts=> waterfall and stock chart => High-Low-Closing.

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.

Excel high low range