We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Different colors for databar [closed]

asked 2019-03-14 08:53:20 +0200

Laniakea gravatar image

updated 2021-05-27 10:51:37 +0200

Alex Kemp gravatar image

Hey there!

Does an option exist that can turn the databar different colors for certain ranges?

image description

i.e. can the bars turn from green (100% to 75%) through yellow (>75%; ≤50%) to red (>50%) ?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2021-05-27 10:51:51.598786

1 Answer

Sort by » oldest newest most voted

answered 2019-03-14 09:33:52 +0200

ebot gravatar image

updated 2019-03-14 09:37:56 +0200

I could not find a solution. If you use color bars / color scale (3 entries), you can work with 3 colors. But then you have no bar anymore. An alternative would be a duplication with different "conditional formatting". Maybe this can help you? I wish you success.

image description

Sorry for the German-UI.

Here you will find further information about "Conditional Formatting".

And here is a guide in English.

If my answer did solve your problem, please click the big checkmark inside the circle to the left of this answer. It then indicates to the other participants that the question has been answered correctly.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2019-03-14 08:53:20 +0200

Seen: 228 times

Last updated: Mar 14 '19