Its Driving Me Crazy

[rosealex]

Hey Guys,

I am hoping that someone can help me with this as I have no idea how its done.
Please, take a look at the image and let me now how can I get this effect with a line and a shaded area that follows the line. The worst thing is that there is no formula on the page, but I am also sure that its not a "preset". Unfortunately, it is taken from a video so I cannot figure it out.

THANKS!

 

[Hui]

This is simply an Area Chart with Blue Fill and White line color?
It has two series
Series 1 Base line is simply your Average line in your case 50
Series 2 is simply the difference between your data and the Average


Then make a chart using the Base Line and +/-'ves

Format to suit

see the chart here: Chart.xlsx

For the Shadow, select the Series,
Right Click and Format Data Series,
Shadow

play around until you get the desired effect

 

[rosealex]

Hey Hui,

Thanks a lot for this! Its greatly appreciated!

All the best,
Alex