非常漂亮的excel图表模板.xls

Item AItem BItem CNegative Item DTotal Jan0 080 511 31 1 900 00 Feb1 001 321 18 1 611 89 Mar1 711 951 02 1 563 12 Apr2 082 021 53 1 663 97 May2 252 101 18 1 573 96 Jun2 992 621 30 1 105 81 Jul3 023 241 57 1 756 08 Aug3 504 091 46 1 058 00 Sep3 724 901 49 1 468 65 Oct4 545 111 07 1 589 14 Nov5 165 851 73 1 9810 75 Dec5 576 741 93 1 7312 50 Chart Title JanFebMarAprMayJunJulAugSepOctNovDec 4 2 0 2 4 6 8 10 12 14 16 Negative Item D Item C Item B Item A Chart Title JanFebMarAprMayJunJulAugSepOctNovDec 4 2 0 2 4 6 8 10 12 14 16 Negative Item D Item C Item B Item A Series 1Series 2Series 3Series 4 Jan7 419 385 526 25 Feb5 748 277 293 39 Mar6 525 427 516 20 Apr2 020 700 241 88 May7 900 359 996 84 Jun3 228 010 911 61 Jul1 438 548 087 62 Aug9 807 798 718 21 Sep2 368 175 704 48 Oct4 399 717 194 96 Nov3 240 267 651 37 Dec8 447 789 443 65 Chart Title JanFebMarAprMayJunJulAugSepOctNovDec 5 10 15 20 25 30 35 40 Series 1Series 2 Series 3Series 4 Chart Title JanFebMarAprMayJunJulAugSepOctNovDec 5 10 15 20 25 30 35 40 Series 1Series 2 Series 3Series 4 Series 1Series 2Value Jan7 214165 2 013487 3 670265 Feb6 584182 2 0356138 4287 Mar6 865548 4 676022 4 144397 Apr1 295866 6 9219471 04951 May8 3771346 82327 9 241961 Jun8 583299 1 367746 1 516886 Jul7 810358 0 562483 8 258197 Aug6 049414 7 147087 6 098933 Sep8 973682 7 780544 3 170938 Oct4 577469 6 099524 4 852386 Nov2 877602 6 311773 6 630168 Dec6 329376 1 735717 2 335896 Chart Title 10 90 80 70 60 50 40 30 20 10 2 4 6 8 10 12 Chart Title 10 90 80 70 60 50 40 30 20 10 2 4 6 8 10 12 Value Category A5 Catedgory B4 Category C3 Catedgory D2 Category E1 Category A 5 Catedgory B 4 Category C 3 Catedgory D 2 Category E 1 Chart Title Category A 5 Catedgory B 4 Category C 3 Catedgory D 2 Category E 1 Chart Title Value Category A5 Category B4 Category C3 Category D2 Category E1 Category A 5 Category B 4 Category C 3 Category D 2 Category E 1 Chart Title Category A 5 Category B 4 Category C 3 Category D 2 Category E 1 Chart Title Series 1Series 2Series 3Series 4 Jan3 014 649 711 56 Feb3 535 2210 172 48 Mar3 955 3110 623 44 Apr4 515 8711 373 51 May5 376 5312 013 84 Jun6 276 8512 394 32 Jul7 007 6113 274 52 Aug7 098 3213 555 49 Sep7 678 5313 845 76 Oct7 869 5214 125 90 Nov8 2810 0414 956 12 Dec9 0210 5515 526 98 Chart Title JanFebMarAprMayJunJulAugSepOctNovDec 2 4 6 8 10 12 14 16 18 Series 1Series 2 Series 3Series 4 Chart Title JanFebMarAprMayJunJulAugSepOctNovDec 2 4 6 8 10 12 14 16 18 Series 1Series 2 Series 3Series 4 Series 1Series 2Series 3Series 4 Jan7 419 385 526 25 Feb5 748 277 293 39 Mar6 525 427 516 20 Apr2 020 700 241 88 May7 900 359 996 84 Jun3 228 010 911 61 Jul1 438 548 087 62 Aug9 807 798 718 21 Sep2 368 175 704 48 Oct4 399 717 194 96 Nov3 240 267 651 37 Dec8 447 789 443 65 Chart Title Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 403530252015105 Series 1Series 2 Series 3Series 4 Chart Title Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 403530252015105 Series 1Series 2 Series 3Series 4 NameAB AVGHRBBK Nomar Garciaparra 305 334 12 28 17 Albert Pujols 291 330 32 57 26 Scott Hatteberg 268 321 9 43 21 Lance Berkman 335 316 26 50 64 Travis Hafner 325 311 29 72 74The top 25 and bottom 25 of each Justin Morneau 337 309 25 27 60column are colorized using conditional formatting Lyle Overbay 357 305 16 34 57 Paul Konerko 348 302 24 39 56 Nick Johnson 324 302 14 63 53 Shea Hillenbrand 296 301 12 14 40 Adri n Gonz lez 338 299 18 21 62 Jim Thome 317 297 32 61 99 Kevin Youkilis 353 289 11 60 76 Mike Jacobs 296 284 14 30 63 Todd Helton 292 284 11 59 37 Todd Walker 297 283 5 35 26 Ryan Howard 342 281 31 37 104 Doug Mientkiewicz 307 280 4 35 49 Prince Fielder 358 279 17 29 82 Michael Cuddyer 299 271 12 37 71 Chris Shelton 332 271 16 31 92 Adam LaRoche 293 270 17 33 72 Mark Teixeira 383 269 13 53 75 Conor Jackson 276 264 8 40 37 Jeff Conine 280 261 7 26 38 Nick Swisher 337 258 21 62 90 Jason Giambi 294 255 28 68 74 Carlos Delgado 336 250 24 39 84 Adam Dunn 349 246 30 73 113 Brad Wilkerson 280 239 15 37 99 Richie Sexson 361 224 19 35 99 The top 25 and bottom 25 of each column are colorized using conditional formatting Item AItem BItem CNegative Item DTotal Jan0 270 981 68 1 721 20 Feb0 451 081 68 1 112 10 Mar0 881 251 97 1 952 14 Apr1 391 851 78 1 243 78 May1 432 541 02 1 613 38 Jun2 163 291 97 1 406 02 Jul2 743 731 44 1 466 45 Aug3 653 831 31 1 287 51 Sep3 834 261 67 1 728 03 Oct4 175 141 23 1 828 72 Nov5 106 081 02 1 0411 15 Dec5 506 401 33 1 4611 78 Chart Title JanFebMarAprMayJunJulAugSepOctNovDec 4 2 0 2 4 6 8 10 12 14 Negative Item D Item C Item B Item A Total Chart Title JanFebMarAprMayJunJulAugSepOctNovDec 4 2 0 2 4 6 8 10 12 14 Negative Item D Item C Item B Item A Total ValueChange Start100 Step 18020 Step 27010 Step 3628 Step 45210 Final result52 Italics are calculated values Grey are data entry 100 52 0 20 10 8 10 0 Chart Title StartStep 1Step 2Step 3Step 4Final result 100 52 0 20 10 8 10 0 Chart Title StartStep 1Step 2Step 3Step 4Final result Series 1Series 2 Category A0 385 Category B3 003 Category C0 395 Category D1 378 Category E8 4810 Category F0 572 Category G1 593 Category H0 673 Category I2 044 Category J5 099 Category K0 651 Category L0 021 Chart Title Category A Category B Category C Category D Category E C