|
A candlestick chart is one of Excel’s standard chart types. Before creating your chart you need to
arrange your historical pricing data in the order of date, open, high, low. Select the data you want to
chart including the column headings. Select Chart… from Excel’s
Insert menu.

This action launches the chart wizard. In Step One select the Stock chart type and click on the graphic
of the candlestick chart under chart sub-type. Continue through the steps of the wizard to create your
candlestick chart.
|