If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Banded chart with Trend
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 |
Thread Tools | |
Display Modes | |
|
|