Excel Charts & Colours

[mark goodridge]

Hi,

I have a list of profit & loss variances between actual & budget. I am wanting to show all of these variances on a bar chart. The problem arises in that i am wanting to show positive variances as a green block and negative variances as a red block.

Can this be done?

Thank you,

Mark

 

[VoG]

This may help http://www.andypope.info/charts/Invertneg.htm

 

[mark goodridge]

Thank you for the speedy response, much appreciated!!

Kind regards,

Mark