Office 2003 Area Chart Fill

[zagadka]

Hi there,

After finding little on the internet about it, I'm going to have to ask for some advice.

We occasionally have to produce a graph of figures for a "Team Brief" that will give our staff an idea of where we are at. We currently display this as an area chart.

What we'd like to happen is that all the area in the positive be green and that all the area in the negative be red (for obvious reasons).

There seems to be an "invert when negative" for bar charts, but nothing for area charts. For the time being I am having to stoop so low as to print screen the chart and fill the bottom area red in Photoshop! A very long winded way of doing it!!

If anyone could give some assistance I would be very grateful!

I have attached an example .xls of what I am currently getting.

area_negative.zip

Edited June 10, 2008 by zagadka