Hi,

Try this blog post.
http://peltiertech.com/WordPress/200...t-if-negative/

Cheers
Andy

chi_town_eric wrote:
Greetings everyone.

To be brief, I have a two line series which compares monthly prices to a
constant benchmark (January 2008) in US dollars and Euros. I have been asked
to shade the areas between the lines where the change in US dollars is
greater than the change in Euros (in blue) and the other way around (in red).
I have been playing around with area charts using a time series X-axis
rather than monthly values, but the graphs aren't quite right.

I found some posts online from Jon Peltier and from Andy Pope, but they
haven't offered an answer to this specific question. In the following
article, Jon mentions two color shading for areas between lines, but I
didn't see a link to a more specific example:

http://pubs.logicalexpressions.com/P...cle.asp?ID=590

If anyone has any insights, I would appreciate it!

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info