+ Reply to Thread
Results 1 to 2 of 2

problem/question with area or line chart for x axis

  1. #1
    Registered User
    Join Date
    07-28-2007
    Posts
    9

    problem/question with area or line chart for x axis

    I need a 3d chart that will plot on the depth axes the series, on the category axis the position (-8 cm to + 8 cm) and on the z axis percent grow

    Anyway, I can't get the x axis (category) to be linear (I have measured only at -8, -4, -2, -1, 1, 2, 4, 8 cm) but on the chart "-8" to "-4" is the same distance as "-4" to "-2" etc...how can I fix this?
    Attached Images Attached Images

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,829
    Excel doesn't offer any kind of 3D scatter plot.

    the only way to simulate the effect in Excel is to enter some "dummy point" to space the real points out properly. In your case, you'll need dummy points at +/-7,+/-6,+/-5, +/3, 0.

    Either that or use a different graphing program that allows for 3D scatter plots. I don't do 3D plots, so I don't have any specific recommendations.

+ 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