charting two stocks as candlesticks in same graph

[nathan11]

Hi,
I want to graph in one same candlestick chart two stocks over the same
period. how do i do that?
can i do it for two dif time periods as well?
i.e. in same graph i want feb-jun of year 1 and feb-jun of year 3 of
the same stock/index .

 

[Jon Peltier]

One set of OHLC can go on the primary axis and the other on the secondary
axis. This is a bit tricky to produce. Make a candlestick with the first set
of OHLC. Copy the range with the second set, including the dates, select the
chart, and use Edit menu > Paste Special to add the data as new series with
the appropriate options. This messes up the candlestick, but we'll fix it.
Select each of the second set of OHLC series, press F1 to format, and on the
Axis tab, choose Secondary. All of these will now be regular line chart
series. Double click one of the secondary axis series, and on the Options
tab, choose the High-Low Lines and Up-Down Bars options. Then format each of
these series on the Patterns tab to have no markers and no lines.

The conversion of line chart to candlestick is described in this article:

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

- Jon