3d plots

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nora Jean Colligan - 30 Sep 2003 01:10 GMT

I have 3 data series that I want to plot on separate axes on a 3d plot, but
excel
does something weird when I try to do this. Is this possible to do in
excel? Any pointers? Thanks

Signature

----------------------
Nora Jean Colligan
Northwestern University, Evanston, IL. USA
n-colligan@northwestern.edu

Reply to this Message

Jon Peltier - 30 Sep 2003 17:40 GMT

Nora -

Excel does not do true 3D scatter charts. If you need something more
than a surface/contour chart, you might try Andy Pope's
(http://andypope.info) simulated 3D chart, which coerces a 2D scatter
chart into the role, using lots of worksheet formulas and a few dummy
series that fill in for axes.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

> I have 3 data series that I want to plot on separate axes on a 3d plot, but
> excel
> does something weird when I try to do this. Is this possible to do in
> excel? Any pointers? Thanks

Reply to this Message

dvt - 30 Sep 2003 20:25 GMT

> I have 3 data series that I want to plot on separate axes on a 3d
> plot, but excel
> does something weird when I try to do this. Is this possible to do in
> excel? Any pointers? Thanks

I don't quite understand your question, but I can give you a pointer to
Tushar Mehta's primer on 3D charts. http://www.tushar-mehta.com/, look for
Charts/3D Surface on the left side.

Dave

Reply to this Message