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?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Cyril

    Chart Trend Line formula

    Cyril, Aug 15, 2003, in forum: Microsoft Excel Charting
    Replies:
    0
    Views:
    779
    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:
    931
    Jon Peltier
    Aug 11, 2004
  3. Guest

    Can I create multiple trend lines in a chart?

    Guest, Oct 13, 2004, in forum: Microsoft Excel Charting
    Replies:
    2
    Views:
    2,805
    Jon Peltier
    Oct 16, 2004
  4. Guest

    Chart point colours to show time trend

    Guest, May 11, 2005, in forum: Microsoft Excel Charting
    Replies:
    7
    Views:
    265
    Andy Pope
    May 13, 2005
  5. LeAnne
    Replies:
    2
    Views:
    2,627
    LeAnne
    Dec 1, 2005
  6. Lynne

    Horizontally Banded Chart Background

    Lynne, Apr 29, 2007, in forum: Microsoft Excel Charting
    Replies:
    4
    Views:
    500
    Lynne
    Apr 30, 2007
  7. JDB
    Replies:
    3
    Views:
    946
  8. OraPronobis

    Horizontally banded chart background

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