Anyone know of a plugin for Excel that provides the ability to plot 4 data dimensions on a single chart?
I'm having trouble visualizing that, but can you use color or patterns to convey your fourth axis?
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.
Like this one (cool!):
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)
check out xlstat: http://www.xlstat.com/
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
Check out the XLColorMap at http:\\www.quickmetrics.com
Fog Creek Home