DJFANDANGO
Board Regular
- Joined
- Mar 31, 2016
- Messages
- 111
- Office Version
- 365
- Platform
- Windows
Good morning all,
Another question to my esteemed excelers!
I have 30 teams that perform 8 activities each (lots)... which graph/suggestion should I use to show these numbers without looking really cluttered?
See below what I have...
Just for reference I only have about a 1/3 of an A4 sheet to display this on... :-/
Many thanks in advance.
Another question to my esteemed excelers!
I have 30 teams that perform 8 activities each (lots)... which graph/suggestion should I use to show these numbers without looking really cluttered?
See below what I have...
Just for reference I only have about a 1/3 of an A4 sheet to display this on... :-/
Many thanks in advance.
Book1 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
1 | Team | Item 1 | Item 2 | Item 3 | Item 4 | Item 5 | Item 6 | Item 7 | Item 8 | ||
2 | 1 | 1044 | 928 | 1128 | 557 | 1593 | 950 | 84 | 1193 | ||
3 | 2 | 341 | 463 | 1129 | 310 | 23 | 126 | 675 | 940 | ||
4 | 3 | 609 | 930 | 731 | 278 | 310 | 431 | 558 | 1528 | ||
5 | 4 | 661 | 691 | 999 | 1219 | 1219 | 170 | 13 | 1523 | ||
6 | 5 | 164 | 953 | 698 | 1542 | 448 | 8 | 1453 | 1024 | ||
7 | 6 | 64 | 900 | 1332 | 1253 | 257 | 549 | 338 | 667 | ||
8 | 7 | 1328 | 822 | 1438 | 1163 | 146 | 1345 | 1501 | 333 | ||
9 | 8 | 354 | 439 | 1484 | 973 | 582 | 1115 | 1434 | 1439 | ||
10 | 9 | 168 | 1199 | 806 | 889 | 941 | 1456 | 101 | 517 | ||
11 | 10 | 378 | 1170 | 907 | 1311 | 884 | 1427 | 672 | 935 | ||
12 | 11 | 480 | 1325 | 37 | 914 | 371 | 483 | 922 | 939 | ||
13 | 12 | 106 | 54 | 1362 | 1599 | 50 | 1585 | 181 | 316 | ||
14 | 13 | 744 | 384 | 1267 | 22 | 794 | 549 | 1367 | 1292 | ||
15 | 14 | 1423 | 9 | 70 | 635 | 1542 | 12 | 589 | 37 | ||
16 | 15 | 792 | 1585 | 1176 | 1403 | 1354 | 1422 | 1342 | 833 | ||
17 | 16 | 481 | 1173 | 210 | 918 | 1120 | 1315 | 1022 | 591 | ||
18 | 17 | 795 | 1205 | 664 | 886 | 36 | 1052 | 1539 | 580 | ||
19 | 18 | 1485 | 268 | 1230 | 1568 | 216 | 680 | 704 | 1468 | ||
20 | 19 | 1177 | 1291 | 877 | 1475 | 1581 | 924 | 997 | 489 | ||
21 | 20 | 288 | 1321 | 473 | 888 | 691 | 907 | 130 | 521 | ||
22 | 21 | 593 | 710 | 725 | 784 | 1170 | 492 | 1095 | 112 | ||
23 | 22 | 114 | 677 | 1276 | 457 | 967 | 497 | 171 | 854 | ||
24 | 23 | 30 | 1570 | 1226 | 780 | 150 | 1438 | 650 | 1362 | ||
25 | 24 | 662 | 662 | 369 | 951 | 711 | 1408 | 567 | 117 | ||
26 | 25 | 1363 | 688 | 359 | 1247 | 1487 | 1110 | 705 | 1418 | ||
27 | 26 | 761 | 98 | 239 | 1448 | 184 | 1317 | 321 | 172 | ||
28 | 27 | 982 | 49 | 1409 | 1016 | 536 | 1010 | 1115 | 940 | ||
29 | 28 | 675 | 1439 | 937 | 944 | 882 | 1055 | 640 | 906 | ||
30 | 29 | 413 | 85 | 426 | 330 | 525 | 743 | 1473 | 283 | ||
31 | 30 | 1437 | 165 | 1315 | 619 | 1049 | 122 | 951 | 1014 | ||
Sheet1 |
Last edited: