Fog Creek Software
Discussion Board




4D Charts?

Anyone know of a plugin for Excel that provides the ability to plot 4 data dimensions on a single chart?

Specifically I want to chart:
x-axis: priority (4 distinct values possible)
y:axis: severity (4 distinct values possible)
z-axis: phase (5 distinct values possible)
plot-point: a number, representing the number of data values for the x-y-z plot

I'm not stuck on using x-y-z axis as above, nor do I have a particular preference for chart type (bar, plot, etc), but I suspect some kind of bar would be more readable. The above is for example only.

~ ~ Dave

DaveG
Friday, April 09, 2004

I'm having trouble visualizing that, but can you use color or patterns to convey your fourth axis?

Sam Livingston-Gray
Friday, April 09, 2004

Look up "heat map" - that's a 2-D map (usually geographic) representing 3-D data. Use color for your 4th dimension and you'll get a 3-D heat map. BUT I'm not sure how usable it will be.

You might want to reexamine your premises...

Philo

Philo
Friday, April 09, 2004

Like this one (cool!):

http://www.smartmoney.com/marketmap/

Matthew Lock
Friday, April 09, 2004

You may want to check out Visual Spreadsheets by Tableau Software (www.tableausoftware.com).  The product is specifically designed to query and visualize any number of data dimensions from any database.

Christian Chabot (Tableau Software)
Friday, April 09, 2004

check out xlstat: http://www.xlstat.com/

rashmi
Saturday, April 10, 2004

With Panopticon Spreadsheet Mapper, you get a powerful tool for visualizing data in three dimensions simultaneously. The parameters can be changed on the fly. The technology is known as heat maps or tree maps, and the Spreadsheet Mapper plugs into Excel like an additional toolbar, so any data you can import or query into Excel is available for immediate visualization. Try the free evaluation version available at www.panopticon.com

Theo at Panopticon
Wednesday, May 05, 2004

Check out the XLColorMap at http:\\www.quickmetrics.com

It is an Excel add-in which uses a color scale for the third dimension. It's a free download.

Bernard
Tuesday, August 17, 2004

*  Recent Topics

*  Fog Creek Home