Excel 2007 : Graphing RANGE of data along with individual years

[richardlarson87]

Hello -

I am trying to create a graph where I can show the monthly data for:

2010
2011
2006-2011 Average
2006-2011 Range (note this will have a min and max, so it appears as a shaded block in the graph)

So basically what I am looking for is a line graph with 2010, 2011 and the 2006-2011 Average each represented by separate lines, and then the 2005-2010 range should be a block of data shaded within the graph. I know this sounds confusing, so I attached an example of what I am trying to accomplish.

Basically, I just need to know how to plot a range of data in a line graph! Please help!