×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

3d scatter plot

3d scatter plot

3d scatter plot

(OP)
Hi,

Is there a way to make a 3d scatter plot in microsoft excel 2003?
Or any software available that will use the data from the excel spreadsheet to create a 3d scatter plot?

Thanks,
Mike
 

RE: 3d scatter plot

I assume you mean you have x y z triads and you want to fit a surface to them and then display the surface?


xlxtrfun will do that

 

Cheers

Greg Locock

SIG:Please see FAQ731-376: Eng-Tips.com Forum Policies for tips on how to make the best use of Eng-Tips.

RE: 3d scatter plot

(OP)
I don't want to fit a surface, just a scatter plot...i mean just points in x y z triads...

RE: 3d scatter plot

Oh. Hmm. No I haven't seen a way of doing that except by devious means. By that I mean calculating the screen x y coordinates from a known viewpoint.

 

Cheers

Greg Locock

SIG:Please see FAQ731-376: Eng-Tips.com Forum Policies for tips on how to make the best use of Eng-Tips.

RE: 3d scatter plot

Got CAD?

 

RE: 3d scatter plot

If you happen to have grid-type data with equally spaced x data and equally spaced y data, then you might be able to use column chart, subtype 3-d column.  x and y would be treated as category and series respectively.  

Attached is an example.

=====================================
Eng-tips forums: The best place on the web for engineering discussions.

RE: 3d scatter plot

... actually, my idea is pretty lame.  The axes are not presented with 1:1:1 scale.  It is more like a 3-d version of a bar chart than a 3-d version of an x-y chart.  

=====================================
Eng-tips forums: The best place on the web for engineering discussions.

RE: 3d scatter plot

(OP)
Thanks everyone for the input..

electricpete:
I had tried working with the same thing but its nt what i am looking for.

MintJulep:
I have Solidworks 2008....I didn't know we can create 3d scatter plots in Solidworks? If you do then please let me know...

RE: 3d scatter plot

1. Create a part that will act as your data point (sphere, cube, wingnut...).
2. Create a new assembly file.  
3. Insert a wingnut, then constrain it to be x distance away from the yz-plane, y from xz-plane, and z from xy-plane.  
4. Repeat step 3 for remaining data points (could probably be automated with a script/macro).

RE: 3d scatter plot

It's a difficult problem even in CAD.  

The problem with a cloud of points in 3D space is that computer screens and ordinary printers don't give you depth cues, so you don't know how far a point is behind or in front of the viewing plane.   And rotating the viewpoint just makes different sets of points appear to coincide.

[  Just last month I found two lines that behaved oddly with object snaps.  One of them was ~14,000 miles behind the viewing plane.  Go ahead; zoom extents and fix that.
No, I have no idea how it got that way, but I have indications that it may have been copied to hundreds of other drawings.  

Found other lines at similarly bizarre and not clearly related distances, too.  All were inside blocks nested in blocks that were used everywhere.  It's the sort of thing you might leave behind if you were leaving on bad terms... the AutoCAD equivalent of a programmer's code bomb. ]

In a CAD system, you might be able represent 3D scatter data as a perspective view of a 2D array of two- element lines.  I.e. a given data point would be represented by a faint black line whose length is proportional to the distance of a colinear colored line from the xy plane, and the length of the colored line would represent the range of z values for all points with the line's xy value.  Extend that to use two colors if there are three points, etc.  Of course there would be no colored line, or maybe just a colored dot, at the end of the black line if there's only one z value for that xy pair.




 

Mike Halloran
Pembroke Pines, FL, USA

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources