View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Robin Hammond[_2_] Robin Hammond[_2_] is offline
external usenet poster
 
Posts: 575
Default Is it possible to add more than 2 x-axes to a chart?

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


wrote in message
oups.com...
I've seen the custom chart type offering 2 x axes in a single chart. I
wonder if it's possible to program in more than 2? I actually need 3,
believe it or not. I could just use the 3-d view and rotate it to 0
degrees aspect, but that chart object doesn't seem to stretch sideways
as a 2-D view does.

Thanks for any help.

Mark