Emmily
Well-known Member
- Joined
- Oct 5, 2008
- Messages
- 676
Hi, how can i reflect the below data via graph showing trend between the 3 date sets, so Col B-C would be one graph, D-E another and F-G
Excel Workbook | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | 13/05/2011 | Cash Breaks | Security Breaks | > 30 Day Cash | > 30 Day Sec | > 2 No Comm Cash | > 2 No Comm Sec | ||
3 | AFS | 2328 | 24 | 152 | 7 | 1845 | 3 | ||
4 | CCS | 446 | 363 | 61 | 158 | 213 | 23 | ||
5 | SS | 51 | 30 | 33 | 27 | 14 | 0 | ||
6 | |||||||||
7 | 6/05/2011 | Cash Breaks | Security Breaks | > 30 Day Cash | > 30 Day Sec | > 2 No Comm Cash | > 2 No Comm Sec | ||
9 | AFS | 1380 | 36 | 153 | 9 | 1060 | 3 | ||
10 | CCS | 389 | 322 | 50 | 158 | 250 | 37 | ||
11 | SS | 37 | 36 | 19 | 35 | 8 | 0 | ||
12 | |||||||||
13 | 18/03/2011 | Cash Breaks | Security Breaks | > 30 Day Cash | > 30 Day Sec | > 2 No Comm Cash | > 2 No Comm Sec | ||
15 | AFS | 984 | 59 | 153 | 9 | 715 | 8 | ||
16 | CCS | 994 | 523 | 50 | 298 | 661 | 40 | ||
17 | SS | 23 | 38 | 19 | 31 | 0 | 1 | ||
Sheet1 |