Chart overlay and joined secondary chart

[Robgrant]

I created a hi-low-close stock chart with excel, but would like to add an
independent indicator on top of the main chart without disturbing the axis
scale on the main chart. So my first question is: can I make an overlay
chart?

Secondly, if I decide to add another indicator below the original chart, is
there a way to join the two charts, so the data will be aligned?

Thanks

 

[Andy Pope]

Hi,

Have a look at Jon's example.
http://peltiertech.com/Excel/Charts/AlignCharts.html

It may be possible to create a combination chart, which is usually a
better solution than trying to overlay them.

Cheers
Andy

 

[Jon Peltier]

Also refer to this page:

Stock Chart with Added Series
http://peltiertech.com/Excel/Charts/StockChartPlus.html

which guides you through adding an indicator series to a stock chart without
permanently messing up the axes.

I've also gone the route of butting two charts up to each other to get the volume
data plotted under the price data. It's more reliable to use a single chart and
various tricks, but in one occasion I couldn't use my tricks. I had to resort to VBA
to assure alignment of the two time axis scales.

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