Banded chart with Trend

Discussion in 'Microsoft Excel Charting' started by Jul B., Jan 23, 2010.

  1. Jul B.

    Jul B. Guest

    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
     
    Jul B., Jan 23, 2010
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Cyril

    Chart Trend Line formula

    Cyril, Aug 15, 2003, in forum: Microsoft Excel Charting
    Replies:
    0
    Views:
    636
    Cyril
    Aug 15, 2003
  2. Guest

    Excel Chart with 2 bars and 2 trend lines

    Guest, Aug 11, 2004, in forum: Microsoft Excel Charting
    Replies:
    1
    Views:
    800
    Jon Peltier
    Aug 11, 2004
  3. Lynne

    Horizontally Banded Chart Background

    Lynne, Apr 29, 2007, in forum: Microsoft Excel Charting
    Replies:
    4
    Views:
    353
    Lynne
    Apr 30, 2007
  4. JDB
    Replies:
    3
    Views:
    769
  5. OraPronobis

    Horizontally banded chart background

    OraPronobis, Nov 16, 2009, in forum: Microsoft Excel Charting
    Replies:
    1
    Views:
    378
    Bernard Liengme
    Nov 16, 2009
Loading...

Share This Page