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


--
MJSlattery
------------------------------------------------------------------------
MJSlattery's Profile: http://www.excelforum.com/member.php...o&userid=16141
View this thread: http://www.excelforum.com/showthread...hreadid=378438

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