Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Fan Chart in Excel?

  1. #1
    Board Regular
    Join Date
    Dec 2007
    Posts
    123
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Fan Chart in Excel?

    Mr. Excel,

    Looking to create a Fan Chart in Excel.
    Does anyone know of a method, or Excel compatible software.
    Example of Fan Chart here.
    http://www.bankofengland.co.uk/publi...feb09large.gif

    Thank you.
    Mariner191

  2. #2
    Board Regular Bill_Biggs's Avatar
    Join Date
    Feb 2007
    Location
    Planet Texas of the Texan Empire
    Posts
    1,216
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Fan Chart in Excel?

    Go here. If its not here, it can't be done.

    http://peltiertech.com/Excel/Charts/index.html
    Thanks,

    Jesus loves me. If you knew me, you would know how amazing that is. And he loves you too! How amazing is that?!
    t

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

    Default Re: Fan Chart in Excel?

    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

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
  •