A Microsoft Office (Excel, Word) forum. OfficeFrustration

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 » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

parametric graphs



 
 
Thread Tools Display Modes
  #1  
Old April 14th, 2004, 04:25 PM
Sarah
external usenet poster
 
Posts: n/a
Default parametric graphs

Hi all,
This may sound a silly question, but...
I have some data that measures the relationship between
temperature and viscosity of various chemicals. Since this
relationship varies over time, I'd like to add a third
axis (time the measurements are taken).
Is there a way of creating 3axes'd graphs on excel without
using add-ons?
Cheers
Sarah
  #2  
Old April 14th, 2004, 06:04 PM
Jon Peltier
external usenet poster
 
Posts: n/a
Default parametric graphs

Excel cannot deal with charts that have 3 numerical axes.

I've found that two axes are usually sufficient for presentation of this
kind of data, since it's hard to interpret x, y, and z values when the
chart is shown in perspective view. I would make multiple curves of
X=Temperature and Y=Viscosity, with one curve at each measurement time
(or alternatively, switch temperature and time).

Andy Pope has a simulated 3D scatter chart on his web site
(http://andypope.info). If you need a solution outside of Excel, you
might try products like SigmaPlot or DeltaGraph.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Sarah wrote:

Hi all,
This may sound a silly question, but...
I have some data that measures the relationship between
temperature and viscosity of various chemicals. Since this
relationship varies over time, I'd like to add a third
axis (time the measurements are taken).
Is there a way of creating 3axes'd graphs on excel without
using add-ons?
Cheers
Sarah


  #3  
Old April 15th, 2004, 12:17 AM
Tushar Mehta
external usenet poster
 
Posts: n/a
Default parametric graphs

If your independent variable values are all equidistant, you can create
a 3D surface plot. See the Excel/Charts/3D Surface page of my web site.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Business solutions leveraging technology
Microsoft Most Valuable Professional (MVP) 2000-2004

In article ,
says...
Hi all,
This may sound a silly question, but...
I have some data that measures the relationship between
temperature and viscosity of various chemicals. Since this
relationship varies over time, I'd like to add a third
axis (time the measurements are taken).
Is there a way of creating 3axes'd graphs on excel without
using add-ons?
Cheers
Sarah

  #4  
Old April 15th, 2004, 08:42 AM
Sarah
external usenet poster
 
Posts: n/a
Default parametric graphs

Hi Guys,
Thanks for your help, it's great!

Sarah
 




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 Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:22 PM.


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