Mark,

It's really complex in code but if you want to take it on, there is a
technique.

1. Create a stand alone chart sheet with your first data series.
2. Create an embedded chart in a standard sheet.
3. Change the location of the embedded chart to the chart sheet you created
in step 1.
4. Line everything up nicely.

As an illustration

I do Price, High, Low, Close, Moving averages in 1 (as HLC and lines)
Technical price indicator like an RSI or MACD in 2 (as lines)
and add another chart with Volume (as columns)

then export the overall chartsheet as a picture back to a single object in a
normal sheet.

Robin Hammond
www.enhanceddatasystems.com