Produce a fan chart

[Dawson]

Does anyone know how to produce a fan chart in excel similar to this one on the Bank of England website. I would have lower and upper confidence levels of a forecast and I would really only want a graduated fill below and above the correct forecast.


http://www.bankofengland.co.uk/inflationreport/irfanch.htm

 

[Jay Petrulis]

On 2002-04-05 02:40, Dawson wrote:
Does anyone know how to produce a fan chart in excel similar to this one on the Bank of England website. I would have lower and upper confidence levels of a forecast and I would really only want a graduated fill below and above the correct forecast.


http://www.bankofengland.co.uk/inflationreport/irfanch.htm

Just an idea...

Could you create series that overlap until the point where you want the data to fan out? The line chart then might produce the effect you want.

What other characteristics would you be missing with the above suggestion? It seems to me that you wouldn't get the shadowing effect, but that could be overcome.

Bye,
Jay

 

[Chris Davison]

Dawson,

I'm a customer of the B of E on two fronts, I'll give them a call on Monday to see if they can help....

 

[Dawson]

Chris - is that is for real then most appreciated.

The shading is the most important bit really - there is no issue in producing the lines.

Cheers
John

 

[Chris Davison]

Hi John,

the guy's had his answermachine on for the last two days... here's his number, he's head of the website design team

Ian Barnes
0207 601 4906

 

[MT_MANC]

Any success in Fan Chart production method ?

I too have to produce some (widening) standard error/confidence bands around a economic forecast extending to 2018

 

[katchytitle]

Hi,

Go here for a step by step guide to creating a fan chart in excel.

http://peltiertech.com/WordPress/sho...-shaded-bands/

Seems fairly easy but a little fiddly. If anyone creates a custom chart worksheet in Excel for this can they please post it online?

I think the bank of england use a program called Matlab to create their fan charts

 

[Jon Peltier]

Catchy Title's link was broken. Try

Show Uncertainty in Predictions with Shaded Bands