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. 


Thread Tools  Display Modes 
#1




How do I make a 3dimensional plot in Excel?
I wanted to make a 3dimensional plot in Excel and discovered that I cannot
do this. All you can do is make 3D charts over two dimensions, you cannot make 3D 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 
#2




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 3dimensional plot in Excel and discovered that I cannot > do this. All you can do is make 3D charts over two dimensions, you > cannot > make 3D 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 > 
#3




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 3dimensional 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 3dimensional plot in Excel and discovered that I cannot > > do this. All you can do is make 3D charts over two dimensions, you > > cannot > > make 3D 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




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 > 3dimensional 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 3dimensional plot in Excel and discovered that I >> >cannot >> > do this. All you can do is make 3D charts over two dimensions, you >> > cannot >> > make 3D 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




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 > > 3dimensional 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 3dimensional plot in Excel and discovered that I > >> >cannot > >> > do this. All you can do is make 3D charts over two dimensions, you > >> > cannot > >> > make 3D 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




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 >>>3dimensional 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 3dimensional plot in Excel and discovered that I >>>>>cannot >>>>>do this. All you can do is make 3D charts over two dimensions, you >>>>>cannot >>>>>make 3D 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  


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 08:31 PM 
Excel Rejects Chart Scale Changes  Wynn  Charts and Charting in Excel  2  December 10th 04 05:43 AM 
Excel 97 chart opened in Excel 2003  Source Data problem  DHunt  Charts and Charting in Excel  0  December 6th 04 09: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 06:47 PM 
Barb Reinhardt: HOW TO: Plot a Team Name ....  Kevin McCartney  Charts and Charting in Excel  2  December 1st 04 02:28 PM 