Candlestick Charts in Excel 2007:-

A candlestick chart has a vertical line that indicates the range of low to high prices for a security. A thicker column indicates the opening and closing prices. If the price of the security closed up, the thicker column appears in white or green. If the price of the security closed down, the thicker column appears in black or red.

The candlestick chart is so named because each shape appears as a candle with a wick sticking out of the top and the bottom. In the Figure (given below), for example, the security enjoyed five months of gains from July through November, before falling in December. Excel easily creates these charts using the Open-High-Low-Close chart type. In another variant, volumes for each period are plotted on a second axis. You can quickly scan this type of chart to see if the stock has had more winning periods than losing periods.



(The thicker column indicates the open and closing prices. The thinner line indicates the high-to-low range.)