Hi there,
im confused with Excel at the Moment.
im trying to get databars which length are based on the value within the cell but the Color is depending from another keyfigure.
Any idea on how to solve that?
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Achivement[/TD]
[TD]Status[/TD]
[TD][/TD]
[TD]Status bar[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]R[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]45[/TD]
[TD]G[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]80[/TD]
[TD]Y[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Here the first databar should be 10 Long and red, the second should be 45 Long but green and the third should be 80 but yellow.
thx a lot to all.
cheers
im confused with Excel at the Moment.

im trying to get databars which length are based on the value within the cell but the Color is depending from another keyfigure.
Any idea on how to solve that?
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Achivement[/TD]
[TD]Status[/TD]
[TD][/TD]
[TD]Status bar[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]R[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]45[/TD]
[TD]G[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]80[/TD]
[TD]Y[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Here the first databar should be 10 Long and red, the second should be 45 Long but green and the third should be 80 but yellow.
thx a lot to all.
cheers