209
Creating Candlestick Charts
Creating Candlestick Charts
A basic candlestick chart requires a data range with date in the first column, then open,
high, low, and close values in the remaining columns. To create a candlestick chart, you fol-
low these steps:
1. Download data from http://finance.yahoo.com. Your data will be in the correct
sequence, with Date in column A, Open in column B, High in column C, Low in col-
umn D, and Close in column E.
2. Select your data in columns A:E.
3. On the Insert ribbon, select Other Charts, Stock, Open-High-Low-Close. Excel cre-
ates the top chart in Figure 6.28.
6
Figure 6.28
The top chart shows the
default chart created ...