Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Jul 2002
    Location
    Hampshire, United Kingdom
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Positioning within a 3D Plot (2003)

    I'm trying to write some code to add some shapes (lines, boxes, etc.) to a 3D bar chart. The shapes need to be positioned relative to the axes. The trouble I'm having is identifying where the axes, floors and walls actually start relative to the edge of the plot area. Are there any properties that give me this information, or is there some other way to find where things are on a 3-D plot?

    Thanks
    Pete

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Positioning within a 3D Plot (2003)

    If I were you, I'd try to define the shapes as series in the chart itself. It's virtually impossible to do this with shapes floating above the chart, and even if you succeeded, you'd probably find that the shapes wouldn't be positioned correctly on a printout if they are on the screen, and vice versa.

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Positioning within a 3D Plot (2003)

    I am not sure how easy that is in Excel either since the 3-d chart is not an XYZ it is all categorical except for the Z. (unless XL2003 has a new chart type)

    Steve

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Positioning within a 3D Plot (2003)

    > unless XL2003 has a new chart type

    Not as far as I know. But I don't think it's easy to place drawing objects correctly on a 3D chart either...

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Positioning within a 3D Plot (2003)

    I agree, both are difficult

    Steve

  6. #6
    New Lounger
    Join Date
    Jul 2002
    Location
    Hampshire, United Kingdom
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Positioning within a 3D Plot (2003)

    Thanks for your words of wisdom. It looks like I'll have to revert to using 2D charts.

    Pete

Posting Permissions

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