A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Banded chart with Trend



 
 
Thread Tools Display Modes
  #1  
Old January 23rd, 2010, 01:32 AM posted to microsoft.public.excel.charting
Jul B.
external usenet poster
 
Posts: 8
Default 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

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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:16 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.