Change area colour on crossing an axis?

C

crusty spaceman

I am trying to create a chart showing bank account details when th
account is positive I would like to have the area below the chart i
green and when it goes overdrawn this should be in red.

The invert if negative function does not appear to be available for a
area chart - is there any other way to do this
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't format 'invert if negative' colour programmitically (macroignores it!) 0
Convert Error Bars to Series and Colour 1
sideways stacked bar charts with line series on the same axis 0
change the colour of the "invert if negative" option in Excel 1
Colour plot area of a dual axis x,y chart 3
Waterfall chart difficulties 2
One extra x axis item that wont go away - can anyone help? 3
change chart primary horizontal axis label or name 1

Top