PC Review


Reply
Thread Tools Rate Thread

Banded chart with Trend

 
 
Jul B.
Guest
Posts: n/a
 
      23rd Jan 2010
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

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Horizontally banded chart background OraPronobis Microsoft Excel Charting 1 16th Nov 2009 06:24 PM
Horizontally Banded Chart Background. - on Stock charts JDB Microsoft Excel Charting 3 13th May 2008 05:38 AM
Horizontally Banded Chart Background Lynne Microsoft Excel Charting 4 30th Apr 2007 03:19 PM
Can I have siblings in a banded data access page? =?Utf-8?B?TWFyayBIaW5uZWJ1c2No?= Microsoft Access 8 31st Dec 2003 01:01 AM
Not banded reports in C#? Marcello Dias Microsoft Dot NET Framework Forms 0 30th Dec 2003 06:21 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:41 PM.