Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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. Is it possible with VBA or is there a solution for Excel?

share|improve this question

1 Answer 1

I think this is exactly what you need:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=590

It uses the difference between the lines to fill the required regions of the plot.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.