Making a chart display only two colors

You can do it for each series at a time (there might be a way to select multiple series to do them all together, but I'm not enough of a chart guru to know it, sorry).
1. On the chart, left-click on a bar to select one series.
2. Right-click on it and choose 'Format Data Series'.
3. Select 'Fill' on the left-hand side.
4. On the right-hand side, choose 'Solid fill' (some others may work too, but this is the easiest to see).
5. Below the radio buttons, select the box labelled 'Invert if negative'. You'll see a second colour box appear under 'Fill Color' below.
6. Choose Green on the left-hand 'Fill color' and Red on the right-hand.
7. Repeat for the rest of the Data Series.

It takes a bit of time but works. I've done it for the chart on your example sheet, attached.

Hope that helps.

@dragosalaamii
Okay - good luck, sorry I can't help with that.

@sandy666
Thanks for the tip.

Glad you got it working and thanks for sharing it with us.