Hi
Is it possible to export the settings in effect when selected?
We drive ton of reports from the same table.
Some reports need manually selected filter criteria.
We would like to memorialize them as either a formula, macro, or VBA routine so that these can be reliably reset by someone other...
hi
Have you seen Fabrice's Treemap? I think it is ideal for representing disparate values, which it does by their relative size, and rate of change, depicted by changes in color.
best
drew
http://sparklines-excel.blogspot.com/2009/12/treemap-switch-on-light.html