MarkAndrews
Well-known Member
- Joined
- May 2, 2006
- Messages
- 1,970
- Office Version
- 2010
- Platform
- Windows
I have the following table in my workbook
I need to construct a chart from this data, however - here is my dilemma
The chart I need to create, needs to show the month previous for all the ascending category's
So, from a validation cell, If the user selects September - the graph would also (automatically) show the previous months results on the same chart
Currently the data on the above table is only for 4 months, but this will grow
(There is no data on this document before September)
I am really stumped & would appreciate any help - Unfortunately i'm on a today deadline
Hope this all makes sense
TIA
Mark
Customer Services MI Sep 06+.xls | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
31 | Reason | Sep | Oct | Nov | Dec | ||
32 | LevelofService-general | 17 | |||||
33 | LackofCallbacks | 0 | |||||
34 | PoorCommunication | 0 | |||||
35 | FeeEarnerDelays | 1 | |||||
36 | CompletionDelay | 15 | |||||
37 | CompletionIssues | 13 | |||||
38 | RedemptionIssue | 2 | |||||
39 | RedStatIssues | 2 | |||||
40 | Shortfall | 1 | |||||
41 | Surplus | 4 | |||||
42 | ProcessIssue | 0 | |||||
43 | PCTIssues | 0 | |||||
44 | TitleDeedsIssue | 5 | |||||
45 | RegistrationIssue | 1 | |||||
46 | DocumentIssues | 5 | |||||
47 | DPA | 1 | |||||
48 | Postage | 0 | |||||
49 | CACIssues | 1 | |||||
50 | SystemIssues | 0 | |||||
51 | Fees | 3 | |||||
52 | ThirdPartyIssues | 0 | |||||
53 | Other | 4 | |||||
54 | GrandTotal | 75 | 0 | 0 | 0 | ||
User Entry |
I need to construct a chart from this data, however - here is my dilemma
The chart I need to create, needs to show the month previous for all the ascending category's
So, from a validation cell, If the user selects September - the graph would also (automatically) show the previous months results on the same chart
Currently the data on the above table is only for 4 months, but this will grow
(There is no data on this document before September)
I am really stumped & would appreciate any help - Unfortunately i'm on a today deadline
Hope this all makes sense
TIA
Mark