Plotting 2 stock series?

Does anyone know if it is possible to plot 2 series of
stock data on 1 graph? In other words, I'd like to take
2 sets of H-L-C data, and then create one graph with
primary and secondary axes for both X&Y, that would
accommodate both the primary and secondary set of
Date/H/L/C data.

Thanks,
Jeff Baum

What you could try is to create two charts and overlay one on top of
the other. For the one one top, make the plotarea and chartarea
transparent (double-click each of the chartarea and plotarea and in the
respective dialog boxes, from the Patterns tab, set the Area to
'None'). You will also have to adjust the axes so that only one set is
visible.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <024901c3b06f$a6d2ff10$7d02280a@phx.gbl>, excel@jeffbaum.com
says...
> Does anyone know if it is possible to plot 2 series of
> stock data on 1 graph? In other words, I'd like to take
> 2 sets of H-L-C data, and then create one graph with
> primary and secondary axes for both X&Y, that would
> accommodate both the primary and secondary set of
> Date/H/L/C data.
>
> Thanks,
> Jeff Baum
>
>

Jeff -

Each set of axes can have its own high-low lines, so plot your values
for one stock (Hi1, Lo1, Close1) on the primary axis, and for the other
stock (Hi2, Lo2, Close2) on the secondary axis. Format all hi and low
series to have no markers and no lines, so they are invisible. Format
both close series to use the half tick markers and no lines, and on the
Options tab for both, select High-Low lines. You can format different
colors for the high-low lines for the two axes. Right click on the
chart, select Chart Options, and on the Axes tab, uncheck the secondary
Y axis, so the stocks are on the same scale. If the ranges for the two
charts overlap, the high-low lines will merge together.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Jeff Baum wrote:

> Does anyone know if it is possible to plot 2 series of
> stock data on 1 graph? In other words, I'd like to take
> 2 sets of H-L-C data, and then create one graph with
> primary and secondary axes for both X&Y, that would
> accommodate both the primary and secondary set of
> Date/H/L/C data.
>
> Thanks,
> Jeff Baum
>

I can't seem to get this to work. How do I plot these
values? I can highlight 4 columns (date1,hi1,lo1,close1)
and use the chart wizard to create a stock hi-low chart
for the 1st series, but I cannot figure out how to create
a second hi-low series on the graph. Any suggestions?

Thanks,
Jeff

>-----Original Message-----
>Jeff -
>
>Each set of axes can have its own high-low lines, so
plot your values
>for one stock (Hi1, Lo1, Close1) on the primary axis,
and for the other
>stock (Hi2, Lo2, Close2) on the secondary axis. Format
all hi and low
>series to have no markers and no lines, so they are
invisible. Format
>both close series to use the half tick markers and no
lines, and on the
>Options tab for both, select High-Low lines. You can
format different
>colors for the high-low lines for the two axes. Right
click on the
>chart, select Chart Options, and on the Axes tab,
uncheck the secondary
>Y axis, so the stocks are on the same scale. If the
ranges for the two
>charts overlap, the high-low lines will merge together.
>
>- Jon
>-------
>Jon Peltier, Microsoft Excel MVP
>http://www.geocities.com/jonpeltier/Excel/index.html
>_______
>
>Jeff Baum wrote:
>
>> Does anyone know if it is possible to plot 2 series of
>> stock data on 1 graph? In other words, I'd like to
take
>> 2 sets of H-L-C data, and then create one graph with
>> primary and secondary axes for both X&Y, that would
>> accommodate both the primary and secondary set of
>> Date/H/L/C data.
>>
>> Thanks,
>> Jeff Baum
>>
>
>.
>

Jeff -

You don't need to create a stock chart in the first place, just a line
chart. Let the wizard make all the series with lines and markers, then
format the patterns and axes of the series as I described in my earlier
post.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Jeff Baum wrote:
> I can't seem to get this to work. How do I plot these
> values? I can highlight 4 columns (date1,hi1,lo1,close1)
> and use the chart wizard to create a stock hi-low chart
> for the 1st series, but I cannot figure out how to create
> a second hi-low series on the graph. Any suggestions?
>
> Thanks,
> Jeff
>
>
>>-----Original Message-----
>>Jeff -
>>
>>Each set of axes can have its own high-low lines, so
>
> plot your values
>
>>for one stock (Hi1, Lo1, Close1) on the primary axis,
>
> and for the other
>
>>stock (Hi2, Lo2, Close2) on the secondary axis. Format
>
> all hi and low
>
>>series to have no markers and no lines, so they are
>
> invisible. Format
>
>>both close series to use the half tick markers and no
>
> lines, and on the
>
>>Options tab for both, select High-Low lines. You can
>
> format different
>
>>colors for the high-low lines for the two axes. Right
>
> click on the
>
>>chart, select Chart Options, and on the Axes tab,
>
> uncheck the secondary
>
>>Y axis, so the stocks are on the same scale. If the
>
> ranges for the two
>
>>charts overlap, the high-low lines will merge together.
>>
>>- Jon
>>-------
>>Jon Peltier, Microsoft Excel MVP
>>http://www.geocities.com/jonpeltier/Excel/index.html
>>_______
>>
>>Jeff Baum wrote:
>>
>>
>>>Does anyone know if it is possible to plot 2 series of
>>>stock data on 1 graph? In other words, I'd like to
>>
> take
>
>>>2 sets of H-L-C data, and then create one graph with
>>>primary and secondary axes for both X&Y, that would
>>>accommodate both the primary and secondary set of
>>>Date/H/L/C data.
>>>
>>>Thanks,
>>>Jeff Baum
>>>
>>
>>.
>>
>