A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Charts and Charting in Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

How do I make a 3-dimensional plot in Excel?



 
 
Thread Tools Display Modes
  #1  
Old December 15th 04, 09:05 PM
John W. Mordosky
external usenet poster
 
Posts: n/a
Default How do I make a 3-dimensional plot in Excel?

I wanted to make a 3-dimensional plot in Excel and discovered that I cannot
do this. All you can do is make 3-D charts over two dimensions, you cannot
make 3-D plots over three dimensions. There's the surface plot, but that
only plots x and y along with the series. I want to plot true x, y, and z.
HELP!

John W. Mordosky

Ads
  #3  
Old December 15th 04, 09:25 PM
John W. Mordosky
external usenet poster
 
Posts: n/a
Default

Thank you very much for that link, it was very informative. However, I
should have been more specific, what I am trying to do is make a true
3-dimensional contour plot in Excel with an x and a y axis and the contours
describing the values that I am trying to plot along that x and y axis. Can
anyone help with that? Thanks.

"Frank Kabel" wrote:

> Hi
> try:
> http://www.andypope.info/charts/3drotate.htm
>
> --
> Regards
> Frank Kabel
> Frankfurt, Germany
> "John W. Mordosky" <John W. > schrieb im
> Newsbeitrag ...
> >I wanted to make a 3-dimensional plot in Excel and discovered that I cannot
> > do this. All you can do is make 3-D charts over two dimensions, you
> > cannot
> > make 3-D plots over three dimensions. There's the surface plot, but that
> > only plots x and y along with the series. I want to plot true x, y, and
> > z.
> > HELP!
> >
> > John W. Mordosky
> >

>
>
>

  #4  
Old December 15th 04, 10:48 PM
Michael R Middleton
external usenet poster
 
Posts: n/a
Default

John -

I don't know if you'll call it a "true" 3D plot, but here's one way to do
it.

The x and y axes are category (label) axes, and the labels will be equally
spaced, so your x and y data values (used as labels) should be equally
spaced. The z axis is the only true "value" (numerical) axis.

Arrange the data in a rectangular range of cells. The top left cell is
empty. The rest of the top row contains x values. The rest of the left
column contains y values. The z values are in the body of the range at the
intersection of the x column and y row. Select the entire range, including
the empty cell. Click the ChartWizard, and choose the Surface chart type.

- Mike

www.mikemiddleton.com

+++++++++++++++++++++++++++++++++++++++++++++

"John W. Mordosky" > wrote in
message ...
> Thank you very much for that link, it was very informative. However, I
> should have been more specific, what I am trying to do is make a true
> 3-dimensional contour plot in Excel with an x and a y axis and the
> contours
> describing the values that I am trying to plot along that x and y axis.
> Can
> anyone help with that? Thanks.
>
> "Frank Kabel" wrote:
>
>> Hi
>> try:
>> http://www.andypope.info/charts/3drotate.htm
>>
>> --
>> Regards
>> Frank Kabel
>> Frankfurt, Germany
>> "John W. Mordosky" <John W. > schrieb
>> im
>> Newsbeitrag ...
>> >I wanted to make a 3-dimensional plot in Excel and discovered that I
>> >cannot
>> > do this. All you can do is make 3-D charts over two dimensions, you
>> > cannot
>> > make 3-D plots over three dimensions. There's the surface plot, but
>> > that
>> > only plots x and y along with the series. I want to plot true x, y,
>> > and
>> > z.
>> > HELP!
>> >
>> > John W. Mordosky
>> >

>>
>>
>>



  #5  
Old December 16th 04, 01:33 PM
John W. Mordosky
external usenet poster
 
Posts: n/a
Default

Thanks for the suggestion! My x and y aren't equally spaced, but I think the
chart tells the story I was hoping for. Thanks again!

John

"Michael R Middleton" wrote:

> John -
>
> I don't know if you'll call it a "true" 3D plot, but here's one way to do
> it.
>
> The x and y axes are category (label) axes, and the labels will be equally
> spaced, so your x and y data values (used as labels) should be equally
> spaced. The z axis is the only true "value" (numerical) axis.
>
> Arrange the data in a rectangular range of cells. The top left cell is
> empty. The rest of the top row contains x values. The rest of the left
> column contains y values. The z values are in the body of the range at the
> intersection of the x column and y row. Select the entire range, including
> the empty cell. Click the ChartWizard, and choose the Surface chart type.
>
> - Mike
>
> www.mikemiddleton.com
>
> +++++++++++++++++++++++++++++++++++++++++++++
>
> "John W. Mordosky" > wrote in
> message ...
> > Thank you very much for that link, it was very informative. However, I
> > should have been more specific, what I am trying to do is make a true
> > 3-dimensional contour plot in Excel with an x and a y axis and the
> > contours
> > describing the values that I am trying to plot along that x and y axis.
> > Can
> > anyone help with that? Thanks.
> >
> > "Frank Kabel" wrote:
> >
> >> Hi
> >> try:
> >> http://www.andypope.info/charts/3drotate.htm
> >>
> >> --
> >> Regards
> >> Frank Kabel
> >> Frankfurt, Germany
> >> "John W. Mordosky" <John W. > schrieb
> >> im
> >> Newsbeitrag ...
> >> >I wanted to make a 3-dimensional plot in Excel and discovered that I
> >> >cannot
> >> > do this. All you can do is make 3-D charts over two dimensions, you
> >> > cannot
> >> > make 3-D plots over three dimensions. There's the surface plot, but
> >> > that
> >> > only plots x and y along with the series. I want to plot true x, y,
> >> > and
> >> > z.
> >> > HELP!
> >> >
> >> > John W. Mordosky
> >> >

> >>
> >>
> >>

>
>
>

  #6  
Old December 16th 04, 03:04 PM
Jon Peltier
external usenet poster
 
Posts: n/a
Default

John -

You can, of course, insert sufficient extra rows and columns, and interpolate values
to the inserted X and Y values, so that it mimics equally spaced data. In addition,
you can adjust the interpolation to give a smoother surface, with a better
representation of features like saddle points, which Excel's surface charts are
pretty poor at constructing.

I have written an article about surface and contour charts:

http://pubs.logicalexpressions.com/P...cle.asp?ID=447

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

John W. Mordosky wrote:

> Thanks for the suggestion! My x and y aren't equally spaced, but I think the
> chart tells the story I was hoping for. Thanks again!
>
> John
>
> "Michael R Middleton" wrote:
>
>
>>John -
>>
>>I don't know if you'll call it a "true" 3D plot, but here's one way to do
>>it.
>>
>>The x and y axes are category (label) axes, and the labels will be equally
>>spaced, so your x and y data values (used as labels) should be equally
>>spaced. The z axis is the only true "value" (numerical) axis.
>>
>>Arrange the data in a rectangular range of cells. The top left cell is
>>empty. The rest of the top row contains x values. The rest of the left
>>column contains y values. The z values are in the body of the range at the
>>intersection of the x column and y row. Select the entire range, including
>>the empty cell. Click the ChartWizard, and choose the Surface chart type.
>>
>>- Mike
>>
>>www.mikemiddleton.com
>>
>>+++++++++++++++++++++++++++++++++++++++++++++
>>
>>"John W. Mordosky" > wrote in
>>message ...
>>
>>>Thank you very much for that link, it was very informative. However, I
>>>should have been more specific, what I am trying to do is make a true
>>>3-dimensional contour plot in Excel with an x and a y axis and the
>>>contours
>>>describing the values that I am trying to plot along that x and y axis.
>>>Can
>>>anyone help with that? Thanks.
>>>
>>>"Frank Kabel" wrote:
>>>
>>>
>>>>Hi
>>>>try:
>>>>http://www.andypope.info/charts/3drotate.htm
>>>>
>>>>--
>>>>Regards
>>>>Frank Kabel
>>>>Frankfurt, Germany
>>>>"John W. Mordosky" <John W. > schrieb
>>>>im
>>>>Newsbeitrag ...
>>>>
>>>>>I wanted to make a 3-dimensional plot in Excel and discovered that I
>>>>>cannot
>>>>>do this. All you can do is make 3-D charts over two dimensions, you
>>>>>cannot
>>>>>make 3-D plots over three dimensions. There's the surface plot, but
>>>>>that
>>>>>only plots x and y along with the series. I want to plot true x, y,
>>>>>and
>>>>>z.
>>>>>HELP!
>>>>>
>>>>>John W. Mordosky

>>>>
>>>>
>>>>

>>
>>


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How many data points can you have in an Excel for a Scatter Chart. gregran Charts and Charting in Excel 3 December 10th 04 07:31 PM
Excel Rejects Chart Scale Changes Wynn Charts and Charting in Excel 2 December 10th 04 04:43 AM
Excel 97 chart opened in Excel 2003 - Source Data problem DHunt Charts and Charting in Excel 0 December 6th 04 08:05 PM
Make graphs in Excel all the same size ready to paste into Word - sub210 Charts and Charting in Excel 3 December 1st 04 05:47 PM
Barb Reinhardt: HOW TO: Plot a Team Name .... Kevin McCartney Charts and Charting in Excel 2 December 1st 04 01:28 PM


All times are GMT +1. The time now is 07:43 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 2004-2014 ExcelBanter.
The comments are property of their posters.