Colouring an area on a graph

**HammerTime** · 09-10-2009, 07:46 PM

Hi all,

Is there any way to colour an area between two lines on an excel chart. Referring to the attached example: I have a list of ranked categories, I wish to plot the average of the rankings, the average plus the variance and the average minus the variance. I have done this (see attachment) but now want to colour the area bounded by the lines. Is there a way to do this? or is there a better approach I should attempt?

Thanks

**Palmetto** · 09-10-2009, 08:27 PM

This should be helpful.
Apply Fill Color Between Lines in a Chart

**HammerTime** · 09-10-2009, 09:46 PM

Thanks Palmetto,
I tried using area graphs but they only translate well to line graphs. In this case I have used a scatter plot (to make to graph a vertical distribution), is there a way to translate this method to scatter plots, or will i have to use lines?