I need to create a line chart with a shaded area to show difference between to data ranges

**smotty** · 06-14-2012, 06:34 PM

I have the data below

Week Ending Calls On Hold Active Calls Total Open Calls
06/05/2012 7 21 28
13/05/2012 7 21 28
20/05/2012 7 19 26
27/05/2012 7 18 25
03/06/2012 8 28 36
10/06/2012 8 20 28

I need to create aline chart that displays the total number of calls in one data series and the number of Active calls in another. THe difference is the two data ranges will be the number of calls on hold - I would like this difference in the two data ranges to be a shaded area.

Is this possible.

Thanks in advance.

**NickyC** · 06-14-2012, 09:31 PM

Yes, the easiest way to do it is with an area chart. Set the lowest area to “active calls”, and its fill to “no fill”; set the second area to “calls on hold”, and it will fill the gap between active calls and total calls

**pimpmychart** · 06-15-2012, 03:06 AM

Have a look at sample L5 here:
http://www.pimpmychart.com/english/d...0559f8d08a9201

I need to create a line chart with a shaded area to show difference between to data ranges

LinkBack

Thread Tools

Rate This Thread

Display

I need to create a line chart with a shaded area to show difference between to data ranges

Re: I need to create a line chart with a shaded area to show difference between to data ra

Re: I need to create a line chart with a shaded area to show difference between to data ra

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions