+ Reply to Thread
Results 1 to 3 of 3

How to make a Line Chart with shaded uncertainty band

  1. #1
    HEK
    Guest

    How to make a Line Chart with shaded uncertainty band

    In scenarios, the forecasted values often have a higher uncertainty the
    further they are in the future (like a weather forecast). I would like to
    show this "uncertainty band" in a line chart. Of course this can be done by
    graphing two extra lines for optimistic and pessimistic values, or for any
    limit values, but I would like to shade the area between these upper and
    lower limits, preferably by a transparent colour so gridlines are still
    visible. Anyone with an idea how to do this?
    Thanks for your help,
    Henk

  2. #2
    Andy Pope
    Guest

    Re: How to make a Line Chart with shaded uncertainty band

    Hi,

    You can create the shading by using dummy data plotted as an area chart.
    See here for some examples.

    http://peltiertech.com/Excel/Charts/...f.html#XYArea2
    http://pubs.logicalexpressions.com/P...cle.asp?ID=590
    http://www.andypope.info/ngs/ng21.htm

    You will not be able to get the transparent effect you need though,
    unless you use a shape to provide the fill. See Jon Peltier's page to this.
    http://peltiertech.com/Excel/Charts/VBAdraw.html

    Cheers
    Andy

    HEK wrote:
    > In scenarios, the forecasted values often have a higher uncertainty the
    > further they are in the future (like a weather forecast). I would like to
    > show this "uncertainty band" in a line chart. Of course this can be done by
    > graphing two extra lines for optimistic and pessimistic values, or for any
    > limit values, but I would like to shade the area between these upper and
    > lower limits, preferably by a transparent colour so gridlines are still
    > visible. Anyone with an idea how to do this?
    > Thanks for your help,
    > Henk


    --

    Andy Pope, Microsoft MVP - Excel
    http://www.andypope.info

  3. #3
    HEK
    Guest

    Re: How to make a Line Chart with shaded uncertainty band

    Thank you, Andy! I guess I can work it out now. I think I can keep the
    gridlines with a transparent overlay chart but will have to figure it out.
    Henk

    "Andy Pope" wrote:

    > Hi,
    >
    > You can create the shading by using dummy data plotted as an area chart.
    > See here for some examples.
    >
    > http://peltiertech.com/Excel/Charts/...f.html#XYArea2
    > http://pubs.logicalexpressions.com/P...cle.asp?ID=590
    > http://www.andypope.info/ngs/ng21.htm
    >
    > You will not be able to get the transparent effect you need though,
    > unless you use a shape to provide the fill. See Jon Peltier's page to this.
    > http://peltiertech.com/Excel/Charts/VBAdraw.html
    >
    > Cheers
    > Andy
    >
    > HEK wrote:
    > > In scenarios, the forecasted values often have a higher uncertainty the
    > > further they are in the future (like a weather forecast). I would like to
    > > show this "uncertainty band" in a line chart. Of course this can be done by
    > > graphing two extra lines for optimistic and pessimistic values, or for any
    > > limit values, but I would like to shade the area between these upper and
    > > lower limits, preferably by a transparent colour so gridlines are still
    > > visible. Anyone with an idea how to do this?
    > > Thanks for your help,
    > > Henk

    >
    > --
    >
    > Andy Pope, Microsoft MVP - Excel
    > http://www.andypope.info
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1