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.
Pros
Quickly plot stock data in open high low close format At a glance indication of stock price activity
Cons
Not as well understood as many other chart types A specific chart type mostly seen in the financial world
Author
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.
