Excel 2010: How to color the area between charts?
Posted
by
Quasdunk
on Super User
See other posts from Super User
or by Quasdunk
Published on 2011-01-04T22:04:56Z
Indexed on
2011/01/04
22:55 UTC
Read the original article
Hit count: 215
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?
© Super User or respective owner
