Google Answers Logo
View Question
 
Q: 4D Chart for Excel ( No Answer,   4 Comments )
Question  
Subject: 4D Chart for Excel
Category: Computers > Software
Asked by: kzhu-ga
List Price: $5.00
Posted: 15 Aug 2005 21:56 PDT
Expires: 14 Sep 2005 21:56 PDT
Question ID: 556220
I want a software or someway to display a chart (anykind) to contain 4
kinds of information. Say, for example, I want a chart to show a data
set that contains the width,height,lenth and price of some products. I
have tried Excel's bubble chart, but that can only display three kinds
of data.
Any software is OK, but it must contain at least a demo version that I
can verify the results.
Or, if you can possible program one, I will pay more to do this.

Clarification of Question by kzhu-ga on 16 Aug 2005 06:01 PDT
I need Windows Solution...I don't have a mac..and don't wanaa buy one
Answer  
There is no answer at this time.

Comments  
Subject: Re: 4D Chart for Excel
From: nproctor-ga on 16 Aug 2005 00:24 PDT
 
There is a program called 'Gigawiz' that will allow you to plot a 4-D
contour point charts as well as a 4-D scatter charts using color
coding for the 4th variable.

See examples here:

http://www.gigawiz.com/ChartsG14.html

There is a demo available but the program only runs on certain models of the Mac.

In addition, to purchase it is somewhat expensive - US$349 for a single license.
Subject: Re: 4D Chart for Excel
From: nproctor-ga on 17 Aug 2005 01:49 PDT
 
In that case, check out Grapher 6.0: 

http://www.goldensoftware.com/products/grapher/grapher.shtml

It will allow you to create a 3D bubble plot that shows the change in
four variables.

A demo is also available.


Alternatively, have a look at XLSTAT-3DPlot:

http://www.ozgrid.com/Services/excel-3d-charts.htm

This is a plug-in for Excel that allows you to plot various types of
charts in three dimensions.
Subject: Re: 4D Chart for Excel
From: nproctor-ga on 17 Aug 2005 01:56 PDT
 
Sorry, XLSTAT-3DPlot is not a standalone program (it requires an
installation of XLSTAT-Pro) so is probably not a practical solution.
Subject: Re: 4D Chart for Excel
From: rak1-ga on 07 Sep 2005 20:26 PDT
 
Another option is to use the bubble chart, but use concentric circles
for two dimensions (in addition to the two dimensions used for the X/Y
plot).

The automatic data ranges don't work so well for this, but if you go
into 'Source data / Series' it's easy enough to set up two series with
the same X and Y values, but different size values.

Format the second series to have no fill, so it won't hide the first
series even if that size value is smaller.

Note that the same scaling will be used for the two size dimensions -
in other words, if one is in the range 1-10, say, and the other is
10,000-100,000, the first will be almost invisible.  So, if this is a
problem, scale the units of one or the other before you plot them, so
they're in the same range.

Hope this helps!

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy