Cant get charts to go red

[[email protected]]

Hi all the chart i have the adjustable data is green on sheet 2
The chart uses the data from the top of sheet 2
I would like if i overspend the chart will start filling up again but in a red colour..
Ive tried everything but cant sort this out Please can somebody help..
Chart is on sheet 3
Regards Steve

[gmr4evr1]

One way would be to format the data series and select Invert if negative and change the fill color to red.

[[email protected]]

Hi mate thanks for the reply my excel knowledge is small could you show me how please

[gmr4evr1]

Right click any of the "bars" on your chart then select Format Data Series. Select fill then check the box next to Invert if negative. Another fill color dropdown should appear, select red then click close.
Here is your attached sample with what it looks like when you've done this.
ste67-cant-get-charts-to-go-red-chart.xlsx

[[email protected]]

wow thanks you have done so much so i feel so cheeky but i need the negative red to start going back up the graph not bellow so sorry regards Steve

[gmr4evr1]

You're welcome. I'm not sure if that can be done. If it can, I have no idea how to do it. Sorry about that.

[[email protected]]

No worries thanks for giving it a shot and all your advice

[gmr4evr1]

No problem.