Plotting 2 stock series?

  • Thread starter Thread starter Jeff Baum
  • Start date Start date
J

Jeff Baum

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
 
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
 
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
 
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
 
Back
Top