How to colour a range in bar in spotfire

[Alan Hon]

How to colour a range in bars in spotfire. Let say i have this table:

Table:

Col1 Start End

Apple 1 5

Apple 15 20

Bannana 5 8

Orange 1 2

Bannana 10 15

I want to show horizontally the 3 bars that colour in the range. Let say max value is fixed to 50 for each fruit. Where g: is green, r: is red, x: is gray.

When is at the front i want it to be green.

Apple gggggxxxxxxxxxrrrrrxxxxxxxxxx

Bannna xxxxrrrrxrrrrrrxxxxxxxx...

Orange ggxxxxxxxxxxxxxxxxxxx...

Hope that make sense

 

Thanks,

Alan