How do I draw a candlestick using excel

[Jembo's Boss]

I would like to use excel to draw a candlestick chart using stock price data.
Has anyone done this before

 

[ShaneDevenshire]

Hi,

Here are some examples:

http://peltiertech.com/Excel/ChartsHowTo/StockChartsAndLineChartTricks.html