|
|
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 |
|
There is no answer at this time. |
|
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! |
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 Home - Answers FAQ - Terms of Service - Privacy Policy |