Ask Experts Questions for FREE Help !
Ask
    JohnnyCav's Avatar
    JohnnyCav Posts: 1, Reputation: 1
    New Member
     
    #1

    Oct 25, 2006, 10:12 PM
    Excel line chart with "confidence band"
    Hello, I am new to this forum and need help with a line chart in Excel.

    I have 40 years of annual data, each expressed as a mean with a confidence interval (CI) having an upper limit (UL) and a lower limit (LL). Instead of plotting the data using error bars to show the CI, I wanted to plot 3 smoothed lines on the same chart: all the ULs, all the means, and all the LLs. This was successful, and the resulting chart shows the mean values with the ULs above and the LLs below. So far so good.

    The problem is that the entire chart area is white, and so the area between the UL line and the LL line does not show up well. What I need is to SHADE IN the chart area between the UL and the LL to create a "confidence band" around the mean line. (The idea is that this band grows with time, and I want to show its growth.)

    I have no idea how to do this, so any advice would be greatly appreciated.

    Thanks in advance,
    JohnnyCav

Check out some similar questions!

Excel line chart - no lines [ 9 Answers ]

I made an excel line chart for church attendance on Sunday morning, Sunday night, and Thursday night. The markers are there to show the attendance, but there are no connecting lines even though I chose line chart. I have made a line chart before and it did have the lines. Does anyone know why...

"Na na na na nah?" Song Title/Band help [ 11 Answers ]

I need help identifying a song title. After googling my heart out, I come to you, oh wise ones. The song begins suddenly with fast paced (and steady) driving drums, guitar and piano. It's a band with a male lead singer and the first thing you hear is "Na na na na nah." They repeat that a few...

Periodic "gushing" noise in main water line [ 1 Answers ]

In my basement, the main water line comes in through one of the basement walls. I don't think I've heard this before, but periodically, I hear water rushing noises coming from the line. When I go down to the basement, it's like water is rushing in, stopping, then rushing in, etc... Could be...

Use of a "chorus line" of a song by Bob Marley to print onto a shirt... [ 10 Answers ]

Hello! Would anyone know if it is illegal to print a paragraph or phrase or chorus of one of Bob Marley's songs onto a shirt to sell for retail? Thanks, sky68

"Belly" in basement sewage line - options? [ 4 Answers ]

Thanks for looking in. Here is the situation. I had our basement finished 4 years ago to include the addition of a full bath using the existing roughins. We noticed overtime the basement toilet will not drain properly after flushing. We'll have to plunge it and occasionally this has caused the...


View more questions Search
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.