This chart type automatically plots the full range of values as a single line, with indicates high and low in a given time interval. On top of the line is a bar which indicates open and close values. Dark bars indicate close price is less than open price (a loss), light bars indicate a close price greater than open price (a gain). Excel plots this chart in blank and white only by default.


Quickly plot stock data in open high low close format At a glance indication of stock price activity


Not as well understood as many other chart types A specific chart type mostly seen in the financial world


Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.   

Candlestick chart - 92Candlestick chart - 4Candlestick chart - 45Candlestick chart - 63Candlestick chart - 47