Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
Showing results for 
Search instead for 
Did you mean: 
Former Member

Xcelsius already allows for dynamic coloring through the use of alerts.  As powerful as that is, however, there are multiple cases where one would like a more powerful method to achieve dynamic colors.  These include, for example:

  1. A line chart whose color changes with its slope
  2. A label whose label changes color based on some value
  3. A rectangle whose background color is dynamic

Here is a simple tutorial to make that happen. We will change the color of a text label from red to green using a horizontal slider in two very simple steps.

1. Add the component for which you want dynamic colours

For this example, we'll change the color of a text label using a slider.  So we'll add:

  • A text label; go to its font color and change the color to "Bind to a color", and map this color to cell $B$2

  • A horizontal slider, which we'll use to change the font of the label dynamically.  Set its value to B1, and its range from 0 to 100.

2. Write the Formulas

Add the formulas from the image blow.  The formulas take the value from the slider (B1) and translate that into a color code (B2):

(click for zoomed-in view)

The cells B5:B7 convert the data into 3 numbers between 0 and 255, corresponding to the red, green, blue.  Here, I defined the formulas so that 0=red and 100=green, with middle values interpolating between these two.  Of course, you can replace these to anything you want.  Cells C5:C7 simply convert those numbers into hexadecimal notation.  Finally, B2 merges all values together into the final color string.  Here's what it looks like in action:

And you're done!

Next Steps

This is of course only the beginning.  It is straightforward to edit the formulas in B5:B7 to define any color gradient you want.  In this example, I used only two colors (red and green) but this can be increased to any number you want.

1 Comment
Labels in this area