Chart Formatting

[Adelgarde]

I have a simple line chart showing the difference between 2010 and 2011 for Average Speed of Answer. The results for 2011 are much better than 2010. I want to format the chart by putting a color or pattern between the two lines. Any tips on how to do this? Thanks

 

[Hui]

Do as a stacked area chart

You'll need to rearrange the data so that Series 1 is the low line

Series 2 is the upper line - lower line values

Then change color of Lower line Area Fill to None

and change color of Upper Area Fill to whatever you want

Also change the transparency of the Upper area so that you can see the grid lines through it

 

[Adelgarde]

Hui,


Many thanks! Very cool...