+ Reply to Thread
Results 1 to 3 of 3

Chart - displaying range

Hybrid View

  1. #1
    Registered User
    Join Date
    02-11-2009
    Location
    Europe
    MS-Off Ver
    Excel 2003
    Posts
    3

    Chart - displaying range

    I'm trying to plot a confidence interval range of a forecast but the only way I can do this is with those ugly error bars. I want to have some kind of cloud or area between upper and lower confidence interval lines.

    For example, this is my data:

    data lower upper
    1 0.9 1.1
    2 1.8 2.2
    3 2.7 3.3
    4 3.6 4.4
    5 4.5 5.5
    6 5.4 6.6
    7 6.3 7.7
    8 7.2 8.8
    9 8.1 9.9

    I can use 3 different series but how do I fill the space between upper and lower?

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481

    Re: Chart - displaying range

    Plot the upper and lower series as stacked area. You will need to calculate the gap rather than use the upper values.

    Format the lower series to have no line or fill colour
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    02-11-2009
    Location
    Europe
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Chart - displaying range

    Wow, this works. Thnx!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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