Excel 2010: How to color the area between charts?
- by Quasdunk
Hello,
I asked this question already on stackoverflow but it hasn't been answered yet. Instead I was advised to try it here, so here I go :)
So there's that simple XY-Line-Chart in Excel (2010). It is surrounded by two other graphs which are parallel but offset by the same factor in both the positive and negative direction - something like this:
---------------- (positively offset parallel graph)
---------------- (main graph)
---------------- (negatively offset parallel graph)
Now I want to color the space between the main graph and the offset ones, but I just can't seem to find a way! Is it maybe possible with VBA? Or is there maybe a solution for Excel 2007?