I have several sets of data more complicated but similar to below where I'd
like to chart the best Dept on the upper line, the worst dept on the lower
line, the median in the middle and the trend. I want to expand for
additional charts to include monthly totals, the % involving a particular
category, locations within each dept etc. but thought I'd start out slow.
I've looked at most of the posts and can't find anything exactly as I need.
Any help would be greatly appreciated. Thanks.


Dept FTE Actual 09 Actual 08 Actual 07 Actual 06
Dept 1 169 10 15 16 18
Dept 2 219 4 5 8 10
Dept 3 196 6 9 6 8
Dept 4 68 0 0 2 0
Dept 5 25 0 0 0 0
Dept 6 1 0 0 0 1
Dept 7 6 0 1 0 0
TOTAL 684 20 30 32 37