SAP BusinessObjects Dashboards 4 Cookbook
Categories
- Business Objects (14)
- Best Practices (5)
- Fusion Charts (5)
- Main (11)
- SQL Server (1)
- SSIS (1)
- Uncategorized (2)
- Universe Design (3)
- Web Intelligence (6)
- Xcelsius (29)
- Design Practices (5)
- Excel (4)
- Tips and Tricks (11)
- Workarounds (6)
Archives
- January 2012
- November 2011
- October 2011
- September 2011
- August 2011
- July 2011
- June 2011
- April 2011
- March 2011
- February 2011
- December 2010
- November 2010
- August 2010
- July 2010
- May 2010
- April 2010
- March 2010
- February 2010
- January 2010
- October 2009
- August 2009
- April 2009
- March 2009
- January 2009
- December 2008
- November 2008
- October 2008
Tag Cloud
best practices
bonavista
bulletgraph
Business Objects
Business Objects Dashboards
charting package
conditional formatting
content management
Cookbook
datatable
dianne sawyer
dom
Dynamic Color Binding
Excel
expand
fannie mae
fix
fred carter
frederick carter
Fusion Charts
grid component
imt slider
inovista
java
Java Wrapper
microcharts
opendoc
pathway technologies
Publication
ripoff
SAP BusinessObjects Dashboards
scam
scorecard
sorting
sparkline
spreadsheet table
table
tree grid
universe
User Access
User Management
Web Intelligence
wrapper
Xcelsius
Xcelsius 2008



Simulating Excel Conditional Formatting in Xcelsius
Conditional formatting in Excel is a feature that is very commonly used and very useful in displaying how well a set of values in a table are doing. Unfortunately we can not transfer the dynamic nature of conditional formatting from Excel to Xcelsius if we were to just insert the table selector object. Basically if the initial binding color of a cell was “Green”, it would stay green even though it were to change to “Red” when the value changes.
Please view my video on how to simply accomplish this using a grid component in Xcelsius
Please visit my post on “MyXcelsius” for a more advanced example of conditional formatting in Xcelsius involving dynamic sliders and charts.
You can download the source file for the example here