O'Reilly logo

SAP BusinessObjects Dashboards 4.0 Cookbook by Xavier Hacking, David Lai

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Making component colors dynamic

Dashboard Design 2008 allows users to fully control the coloring of their components based on whatever event they desire. For example, if a major alert were to happen I could dynamically change my background to red in order to signal an emergency. This is extremely useful because developers can not only dynamically control the color of bars on a chart but also the rest of the chart components such as the background and text as well.

How to do it...

  1. On the cell highlighted in yellow E2, we have a COUNTIF statement that will set the bar color to red, if any of the regions has their number of items sold below 40. Otherwise the bar color will be set to blue as shown in the following screenshot:
  2. On the chart properties ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required