Chart overlay and joined secondary chart

  • Thread starter Thread starter Robgrant
  • Start date Start date
R

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