OHLC Charts in Excel 2007:-

An OHLC chart shows a vertical line extending from the low price to the high price for a given period. A dash on the left side of the line indicates the opening price. A dash on the right side of the line indicates the closing price. For example, the chart in the Figure (given below) shows that January opened at 72, the price ranged from 71 to 86, and January closed at 76.



(This is a true OHLC chart. Excel’s built-in types omit the marker for the opening price.)

Excel does not have a built-in style for OHLC charts, but it can create a variant of this chart: Excel’s high-low-close chart shows the vertical line and the closing line on the right side of the line but is missing the marker for the opening price. Excel’s volume-high-low-close chart is a variant of the OHLC chart that is coupled with a volume chart showing trading volume.