Thread: Comples Stock Charts

I want to superimpose a three band trading channel over the OHLC of my candle stock chart.

I have read the E-Bible for 2003. Gone online to MS Help for Mac Office 2004 and even followed the instructions given by the help button.

Nothing works the way it is advertised. I "get" series instead of "data range".

If anyone has solution to plotting two graphs on one chart I would be grateful.

One solution that is not very pratical is to produce two seperate charts and then set the transparancy to 100% which makes the backgrounds invisiable. You can then superimpose the two charts. It works but if the allignment is not perfect you can misread information from the chart(s). You wind up spending a lot of time re-sizeing the top chart to match the bottom one.

Thanks for any sugestions,

Michael

Michael -

Here's how to add a series to a stock chart. If you can add one, you can
add more.

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

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


MJSlattery wrote:

> I want to superimpose a three band trading channel over the OHLC of my
> candle stock chart.
>
> I have read the E-Bible for 2003. Gone online to MS Help for Mac
> Office 2004 and even followed the instructions given by the help
> button.
>
> Nothing works the way it is advertised. I "get" series instead of
> "data range".
>
> If anyone has solution to plotting two graphs on one chart I would be
> grateful.
>
> One solution that is not very pratical is to produce two seperate
> charts and then set the transparancy to 100% which makes the
> backgrounds invisiable. You can then superimpose the two charts. It
> works but if the allignment is not perfect you can misread information
> from the chart(s). You wind up spending a lot of time re-sizeing the
> top chart to match the bottom one.
>
> Thanks for any sugestions,
>
> Michael
>
>