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.
