Chart conditional format : color scale
Trying to have a Bar chart to mimic a Format conditional color scale and / or apply a conditional format color scale to a chart?
First time here? Check out the FAQ!
Trying to have a Bar chart to mimic a Format conditional color scale and / or apply a conditional format color scale to a chart?
Updated thanks to @ouleyang's hint (upvoted).
Still a little handwork is needed:
Edit
, click on the bars.Format Data Point…
.=HEX2DEC(A2)
in column B.Tested with LibreOffice 6.4.7.2 (x86); OS: Windows 6.1.
It would be great if someone finds a simpler way.
Add Answer is reserved for solutions. If you think the answer is not satisfactory, add a comment below, or click edit (below your question) to add more information. Thanks.
Check the mark ( →
) to the left of the answer that solves your question.
I am not sure I understand exactly what you mean, but the fill color can be taken from a cell, so you just need to configure a formula to get the corresponding color in the cell. You can have something like =IF(A2>2,HEX2DEC("ff0000"),HEX2DEC("00ff00"))
in order to have a red bar for values above 2 and green bar otherwise, then apply this to the whole column of values.
It will not be dynamically linked to the conditional formatting though (you need to update your formula if you update your formatting).
Asked: 2020-12-06 20:22:47 +0100
Seen: 40 times
Last updated: Dec 07 '20
How can I export .ods files with conditional formatting without losing most of it? [closed]
How can I display two cells contents in another cell, both in hour format ? [closed]
Calc conditional drop-menu [closed]
How do I export a chart in an image format from LibreOffice Calc? [closed]
Are there plans for a "papercut" project for libreoffice [closed]
Is it normal for Calc goal seek to take very long? [closed]
Please refine "Search" in Calc - implement functions in Gnumeric [closed]
LibreOffice Calc will not link to external data via internet [closed]