I have a column in OpenOffice calc which contains number values (between 0 and 40). I'd like to add a bar in the background of the cell which shows the value (to give an obvious visual clue which value is larger).
Is that possible somehow?
I don't think that it is possible to have background bars in calc cells.
Another option could be to automatically set the background colour of the cells to different colours based on the value of the cell, e.g. different shades of red, the higher the cell's value, the darker the shade of the cell's background.
To do this:
Repeat for the other ranges of values and background colours.
I've found a workaround: Just create a bunch of columns and set the background of them depending on the cell value. In the cells left to the value column, use a clever text color to make the text invisible (use White to turn it off and the desired bar color for "On").