Why not use conditional formatting to color the cells to an appropriate color
based on the indicator? Access Conditional formatting using FORMAT -
Conditional Formatting.
"stevewoodall" wrote:
In a Balanced Scorecard we use several indicators that are in a binomial or
either/or form: complete or incomplete; on-time or behind, etc. We use
charts in Excel to display other forms of indicators but are having trouble
coming up with a good graphic way of displaying this kind of data.
Any ideas?
|