Scatter AND stock chart

[randy]

I would like to create a chart that plots high/low bars
(ie stock chart) and overlay that information with
scatterpoints. Basically, plot stock movement and on top
of that plot my buys and sells. Any ideas?

 

[Jon Peltier]

Randy -

No sweat. Make your stock chart as usual. Then add a series using your
favorite technique (I copy the range and use Paste Special). Don't panic
when it seems that the new series is mucking up your chart. Instead,
select the series, go to Chart Type on the Chart menu, and select the XY
style you want to use. This converts the series to an XY Scatter type,
and reverts the other series to normal.

I describe some of the ins and outs of adding series to stock charts here:

http://peltiertech.com/Excel/Charts/StockChartPlus.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______