Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default How can I plot a graph using 4 daxes to show relationships?

Hello,

I would like to plot a graph showing the relationships between 4 variables.
(this is engineering, and want to plot values at which failure will occur)

I want to have a mad awesome sweet graph with 4 axis set up and a curve that
goes around and probably joins up somewhere making some kind of shape.

Is there anyway I can do this in excel?

Regards,
Scott
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default How can I plot a graph using 4 daxes to show relationships?

Excel doesn't even do three axes well, certainly not in XYZ value axis form.
I doubt you'll find any graphics package that attempts four axes in 2D space
(i.e., screen or paper).

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


"Captain_Awesome" wrote in
message ...
Hello,

I would like to plot a graph showing the relationships between 4
variables.
(this is engineering, and want to plot values at which failure will occur)

I want to have a mad awesome sweet graph with 4 axis set up and a curve
that
goes around and probably joins up somewhere making some kind of shape.

Is there anyway I can do this in excel?

Regards,
Scott



  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 24
Default How can I plot a graph using 4 daxes to show relationships?

Perhaps Excel's radar chart that sort-of wraps the Category axis around the
origin; it looks as if there are several Y axes coming from a central point
and turns the lines of a line chart into circles around that origin. It
allows you to compare several categories at once to decide which balance of
factors suits you best.

"Captain_Awesome" wrote:

Hello,

I would like to plot a graph showing the relationships between 4 variables.
(this is engineering, and want to plot values at which failure will occur)

I want to have a mad awesome sweet graph with 4 axis set up and a curve that
goes around and probably joins up somewhere making some kind of shape.

Is there anyway I can do this in excel?

Regards,
Scott

  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default How can I plot a graph using 4 daxes to show relationships?

The radar chart is not a very good vehicle for information display. You
could almost as easily make a parallel coordinates chart:

http://peltiertech.com/Excel/Charts/ParallelCoord.html

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


"Jonathan589" wrote in message
...
Perhaps Excel's radar chart that sort-of wraps the Category axis around
the
origin; it looks as if there are several Y axes coming from a central
point
and turns the lines of a line chart into circles around that origin. It
allows you to compare several categories at once to decide which balance
of
factors suits you best.

"Captain_Awesome" wrote:

Hello,

I would like to plot a graph showing the relationships between 4
variables.
(this is engineering, and want to plot values at which failure will
occur)

I want to have a mad awesome sweet graph with 4 axis set up and a curve
that
goes around and probably joins up somewhere making some kind of shape.

Is there anyway I can do this in excel?

Regards,
Scott



  #5   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 24
Default How can I plot a graph using 4 daxes to show relationships?

I'd argue except that I have now read your article and am forced to agree
with you! Thank you for pointing it out.

"Jon Peltier" wrote:

The radar chart is not a very good vehicle for information display. You
could almost as easily make a parallel coordinates chart:

http://peltiertech.com/Excel/Charts/ParallelCoord.html

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


"Jonathan589" wrote in message
...
Perhaps Excel's radar chart that sort-of wraps the Category axis around
the
origin; it looks as if there are several Y axes coming from a central
point
and turns the lines of a line chart into circles around that origin. It
allows you to compare several categories at once to decide which balance
of
factors suits you best.

"Captain_Awesome" wrote:

Hello,

I would like to plot a graph showing the relationships between 4
variables.
(this is engineering, and want to plot values at which failure will
occur)

I want to have a mad awesome sweet graph with 4 axis set up and a curve
that
goes around and probably joins up somewhere making some kind of shape.

Is there anyway I can do this in excel?

Regards,
Scott






  #6   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default How can I plot a graph using 4 daxes to show relationships?

A convert!

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


"Jonathan589" wrote in message
...
I'd argue except that I have now read your article and am forced to agree
with you! Thank you for pointing it out.

"Jon Peltier" wrote:

The radar chart is not a very good vehicle for information display. You
could almost as easily make a parallel coordinates chart:

http://peltiertech.com/Excel/Charts/ParallelCoord.html

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


"Jonathan589" wrote in message
...
Perhaps Excel's radar chart that sort-of wraps the Category axis around
the
origin; it looks as if there are several Y axes coming from a central
point
and turns the lines of a line chart into circles around that origin. It
allows you to compare several categories at once to decide which
balance
of
factors suits you best.

"Captain_Awesome" wrote:

Hello,

I would like to plot a graph showing the relationships between 4
variables.
(this is engineering, and want to plot values at which failure will
occur)

I want to have a mad awesome sweet graph with 4 axis set up and a
curve
that
goes around and probably joins up somewhere making some kind of shape.

Is there anyway I can do this in excel?

Regards,
Scott






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I plot multiple series on one graph? - test-graph.xls (0/1) Leo Bueno Charts and Charting in Excel 1 August 2nd 07 12:49 PM
How do I plot multiple series on one graph? - test-graph.xls (1/1) Leo Bueno Charts and Charting in Excel 0 August 2nd 07 12:14 AM
How do I show break in bar graph to show large and small numbers GK Charts and Charting in Excel 1 December 19th 05 08:23 PM
How do I show break in bar graph to show large and small numbers GK Charts and Charting in Excel 0 December 19th 05 06:35 PM
how do I create a box-plot (or whisker plot ) graph? raal Charts and Charting in Excel 1 August 8th 05 08:31 PM


All times are GMT +1. The time now is 06:30 AM.

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

About Us

"It's about Microsoft Excel"