Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 8 of 8

Thread: Produce a fan chart

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    London
    Posts
    20
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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/infla...rt/irfanch.htm

  2. #2
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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/infla...rt/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

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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....


  4. #4
    New Member
    Join Date
    Mar 2002
    Location
    London
    Posts
    20
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  5. #5
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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
    :: Pharma Z - Family drugstore ::

  6. #6
    New Member
    Join Date
    Sep 2009
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Produce a fan chart

    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

  7. #7
    New Member
    Join Date
    May 2011
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Produce a fan chart

    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

  8. #8
    MrExcel MVP
    Join Date
    May 2003
    Location
    USA
    Posts
    4,515
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Produce a fan chart

    Catchy Title's link was broken. Try

    Show Uncertainty in Predictions with Shaded Bands
    Jon Peltier
    Peltier Technical Services, Inc.
    Try Peltier Tech Charts for Excel

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •