The original article shows how to color the area between two lines in a chart where the lines never cross. I'm going to assume you're like me and you read that blog every day so you already know what I'm talking about.
What if you want to cross the lines? The good news is that crossing the lines doesn't break anything, the area between the lines is still filled in perfectly. The bad news is that the fill series is only one color and as soon as you show it to someone they'll ask why the positive and negative areas aren't green and red, respectively (which you shouldn't do anyway because a lot of people are red/green colorblind). Before today, you would have said that it would take too long to add a second color, that it was impossible, or you would have just drawn auto shapes on top of the chart. Today though there is a much easier solution:
- Download the workbook at the end of this post.
- Plug in your data values.