Graphs - Change colour of bar chart for negative values

[RichardOates]

I have created a bar chart showing sales figures by catagory for the previous week, it shows the % increase or decrease in sales against the previous week.

Is there any way for the bars to automatically be red if negative and green if positive?

Thanks

 

[VoG]

See if this helps http://www.andypope.info/charts/Invertneg.htm

 

[RichardOates]

Perfect, thanks