Excel question

clv101

clv101

clv101

Soldato
Joined
18 Oct 2002
Posts
10,962
Location
Bristol
Does anyone know if it's possible to draw a chart like this in Excel?

20100504_Figure2_thumb.png


What I mean is the grey +/- error band. Each point has a different +/- 2 SD error. I can plot the data with the error bars associated with each point - what I can't work out how to do is draw a grey band like they have here.
 
I'd also be interested in the answer to this for future work.

I've found a method of creating shaded areas:
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=590

But haven't managed to get it looking completely perfect, you'd expect something like this to be an easy function to add.

EDIT: Kinda got it working if you input the higher standard deviation as a series with the lower as another series, making the lower a white background.
 
Last edited:
You must log in or register to reply here.
Back
Top Bottom