+ Reply to Thread
Results 1 to 2 of 2

Is it possible to add more than 2 x-axes to a chart?

Hybrid View

  1. #1
    mgoold2002@hotmail.com
    Guest

    Is it possible to add more than 2 x-axes to a chart?

    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


  2. #2
    Robin Hammond
    Guest

    Re: 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


    <mgoold2002@hotmail.com> wrote in message
    news:1137812435.771472.234700@g49g2000cwa.googlegroups.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
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1