KB42932: How to simulate the implementation of cell conditional formatting feature called Data Bars available in Microsoft Excel 2007 in MicroStrategy 9.4.x-10.x

 
SYMPTOM:
Microsoft Excel 2007 brings a cell conditional formatting feature called Data Bars. According to Microsoft, this feature helps on observing easier how data values relate to each other:
 
 

 
This feature represents data graphically inside the cell, and helps user to compare data cells more effectively and efficiently by adding bars, which defines the data of the cell.
 

 
This feature is not available in Strategy 9.4.x-10.x
  
ACTION:
Customer who'd like this feature in future versions should post to the Ideas Exchange
 
WORKAROUND:
In order to simulate the implementation of this feature in Strategy 9.4.x-10.x, create a set of pre-defined images to be used as threshold intervals; for example:

 
The report appearance will be very similar to the referred feature, as shown:

 
NOTE:
For further information on this Microsoft Excel 2007 feature, refer to the Microsoft Technical document:

• http://msdn.microsoft.com/en-us/library/office/bb229709(v=office.11).aspx
  

 
Third Party Software Installation:
WARNING:
The third-party product(s) discussed in this technical note is manufactured by vendors independent of Strategy. Strategy makes no warranty, express, implied or otherwise, regarding this product, including its performance or reliability.