管理利剑之EXCEL 7 经典图表.xls

序序号号工工作作表表名名称称 1目目录录 21 柱柱形形图图 32 条条形形图图 43 拆拆线线图图1 53 拆拆线线图图2 63 拆拆线线图图3 74 饼饼图图1 84 饼饼图图2 95 XY散散点点图图1 105 XY散散点点图图2 116 面面积积图图 127 圆圆环环图图 138 雷雷达达图图1 148 雷雷达达图图2 159 曲曲面面图图 1610 气气泡泡图图 1711 股股价价图图1 1811 股股价价图图2 1911 股股价价图图3 2012 圆圆柱柱 圆圆锥锥 棱棱锥锥图图 2113 甘甘特特图图 2214 单单点点图图 2315 自自动动更更新新 2416 比比较较柱柱状状 2517 流流程程图图 2618 波波士士顿顿矩矩阵阵 2719 直直方方和和正正态态图图1 2819 直直方方和和正正态态图图2 2920 WBS 返回 YearWidgets Sprockets 199760 98364 983 199856 73268 981 199949 83177 398 200043 32388 091 200139 87993 733 19971998199920002001 0 10 000 20 000 30 000 40 000 50 000 60 000 70 000 80 000 90 000 100 000 Widgets Sprockets 19971998199920002001 0 20 000 40 000 60 000 80 000 100 000 120 000 140 000 160 000 Sprockets Widgets 19971998199920002001 0 10 20 30 40 50 60 70 80 90 100 Sprockets Widgets 100 000 90 000 80 000 70 000 60 000 50 000 40 000 30 000 20 000 10 000 0 19971998199920002001 Widgets Sprockets Widgets Sprockets 100 000 90 000 80 000 70 000 60 000 50 000 40 000 30 000 20 000 10 000 0 19971998199920002001 Widgets Sprockets Widgets Sprockets Item Strongly Agree AgreeUndecidedDisagree Strongly Disagree返回 Store locations are convenient12 14 21 21 32 Store hours are convenient15 18 24 29 14 Stores are well maintained9 11 32 31 17 I like your web site18 32 32 12 8 Employees are friendly2 6 32 43 17 You have a good selection of products16 19 32 21 12 I like your TV ads5 9 32 38 16 You sell quality products24 21 28 15 12 Overall I am satisfied6 28 24 25 17 I would recommend your company3 9 20 27 41 Percent Who Strongly Agree Store locations are convenient Store hours are convenient Stores are well maintained I like your web site Employees are friendly You have a good selection of products I like your TV ads You sell quality products Overall I am satisfied I would recommend your company 30 25 20 15 10 5 0 Survey Results Store locations are convenient Store hours are convenient Stores are well maintained I like your web site Employees are friendly You have a good selection of products I like your TV ads You sell quality products Overall I am satisfied I would recommend your company 100 80 60 40 20 0 Strongly Agree Agree Undecided Disagree Strongly Disagree Survey Results Store locations are convenient Store hours are convenient Stores are well maintained I like your web site Employees are friendly You have a good selection of products I like your TV ads You sell quality products Overall I am satisfied I would recommend your company 100 80 60 40 20 0 Strongly Agree Agree Undecided Disagree Strongly Disagree 19 874返回 19 382 20 064 21 026 22 178 22 110 21 926 21 405 21 733 21 267 21 523 21 865 21 210 21 402 21 610 20 699 20 962 20 195 19 592 19 699 19 617 18 599 17 482返回 17 549 17 970 18 618 19 194 19 712 20 450 19 462 20 677 20 834 21 339 21 507 21 133 21 636 21 659 22 234 22 504 21 902 21 995 21 723 22 008 21 666 21 771 22 970 23 236 22 983 22 183 21 757 22 039 22 175 22 882 23 183 Daily Sales 1112131415161718191101 111 121 131 141 151 161 171 181 191 12 000 17 000 22 000 27 000 32 000 37 000 22 461 22 578 22 404 21 828 21 853 22 140 21 887 21 369 21 087 20 306 20 257 19 996 19 609 19 422 20 001 19 937 20 368 20 959 21 809 21 795 23 145 23 696 23 666 23 841 24 322 25 073 24 808 24 869 24 719 24 457 24 651 24 926 24 115 24 136 23 485 23 360 24 140 23 947 24 082 24 710 24 622 23 995 23 638 23 979 23 811 23 884 22 972 23 540 22 653 21 582 21 226 21 373 22 002 22 255 23 268 24 315 23 682 23 255 23 936 24 438 24 363 25 360 24 413 23 838 24 318 24 648 24 046 24 021 22 947 23 091 23 234 23 312 23 887 23 262 22 572 22 897 23 649 23 739 22 971 23 374 22 803 23 751 23 748 23 797 23 616 23 690 23 135 23 936 24 380 24 324 25 172 25 391 25 367 25 179 26 059 26 488 26 426 26 680 27 149 26 751 26 760 27 197 27 497 27 661 27 878 27 852 27 961 27 739 28 042 27 169 27 454 27 816 28 648 28 506 28 415 29 268 30 140 29 526 29 591 29 379 30 310 30 351 31 715 31 739 31 832 32 722 33 254 32 302 31 571 30 969 30 846 32 098 32 189 32 954 33 919 33 670 33 055 34 396 35 099 34 064 34 643 34 811 34 165 34 477 33 914 33 837 National R D expenditures by source of funds 1953 2000返回返回 IndustryFederalOther 195343 553 92 5 195442 355 22 6 195540 257 42 5 195639 458 62 1 195735 062 92 1 195834 063 92 1 195932 565 42 1 196032 965 02 0 196132 765 12 2 196232 864 82 4 196331 166 52 4 196430 866 82 4 196532 365 22 5 196633 264 22 6 196734 962 42 7 196836 560 72 8 196938 558 62 9 197039 857 03 2 197140 256 43 4 197240 855 83 4 197343 053 63 4 197444 651 83 6 197544 452 03 7 197644 951 53 7 197745 251 03 7 197846 050 23 8 197947 149 23 7 198048 947 53 7 198149 746 73 6 198250 346 13 6 198350 346 23 6 198451 045 53 5 198550 546 03 5 198650 745 53 9 198749 646 44 1 198850 844 94 3 198952 842 64 6 199054 740 64 7 199157 437 84 8 199258 236 85 0 199358 336 55 2 199458 635 95 5 199560 434 35 3 199662 532 15 3 199764 230 55 4 199865 229 55 4 199966 927 75 3 200068 426 35 3 National R D Expenditures By Source of Funds 195319571961196519691973197719811985198919931997 0 10 20 30 40 50 60 70 80 Industry Federal Other National R D Expenditures By Source of Funds 195319571961196519691973197719811985198919931997 0 10 20 30 40 50 60 70 80 Industry Federal Other Population Projections in thousands 返回 California OregonWashington 199531 5893 1415 431 200032 5213 3975 858 200534 4413 6136 258 201541 3733 9927 058 202549 2854 3497 808 50 000 45 000 40 000 35 000 30 000 25 000 20 000 15 000 10 000 5 000 0 19952000200520152025 California Oregon Washington Population Growth 返回 Excel 2002554 Excel 20001082 Excel 97554 Excel 95255 Other version98 返回 Excel 2002 Excel 2000 Excel 97 Excel 95 Other version Excel Usage at XYX Corporation CategoryAmount返回返回 Rent12 909 288 Supplies3 221 904 Miscellaneous2 981 448 Region 1 Salary7 832 288 Region 2 Salary1 959 768 Region 3 Salary3 983 233 Region 4 Salary2 887 309 Salary Rent Supplies Miscellaneous Region 1 Salary Region 2 Salary Region 3 Salary Region 4 Salary Current Year Expenses 5 XY散点图1 Page 18 YearMonthCallsSales返回 2000 Jan90489 Feb89589 Mar89689 Apr88186 May90992 Jun86486 Jul90791 Aug89391 Sep87586 Oct91188 Nov92293 Dec84091 2001 Jan90991 Feb89789 Mar88587 Apr85682 May82581 Jun81577 Jul79976 Aug81385 Sep78876 Oct77775 Nov78677 Dec79897 返回 Relationship Between Outbound SalesCalls And Sales Made 24 Month Period 940920900880860840820800780760740720700 70 75 80 85 90 95 100 Outbound Sales Calls in the Month Sales Made in the Month 5 XY散点图1 Page 19 XY返回 23 63 68 23 返回 109876543210 0 1 2 3 4 5 6 7 8 9 10 返回Product A Product B Product C Qtr 1544933564 Qtr 2705902455 Qtr 33541 243233 Qtr 4812545565 返回 Quarterly Sales by Product Qtr 1Qtr 2Qtr 3Qtr 4 0 250 500 750 1 000 1 250 1 500 1 750 2 000 2 250 Product C Product B Product A 1 400 1 200 1 000 800 600 400 200 0 Qtr 1Qtr 2Qtr 3Qtr 4 Product A Product B Product C Quarterly Sales by Product Sales by State返回 1st Half2nd Half California21 704 71417 987 034 Oregon8 774 09912 214 447 Washington 12 094 21510 873 099 Total42 573 02841 074 580 返回 51 21 28 44 30 26 Sales Breakdown by State California Oregon Washington 1st Half 2nd Half Sales Breakdown by State 1st Half2nd Half 0 10 20 30 40 50 60 70 80 90 100 Washington Oregon California 返回RedGreenBlue返回 Color 112825564 Color 23333255 Color 3128128128 Color 422255255 Note The color palette for this workbook was modified to include the three colors shown in the charts These colors are not normally part of the default color palette Color 1 Red GreenBlue 5 55 105 155 205 255 Color 2 Red GreenBlue 5 55 105 155 205 255 Color 3 Red GreenBlue 5 55 105 155 205 255 Color 4 Red GreenBlue 5 55 105 155 205 255 返回Snow Ski SalesWater Ski Sales Jan6 8971 983 Feb7 7325 547 Mar4 5007 330 Apr3 1229 832 May89310 739 Jun73416 453 Jul89115 874 Aug5599 833 Sep5 4334 312 Oct8 7344 433 Nov11 8737 545 Dec18 7309 832 返回 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Snow Ski Sales Water Ski Sales 返回00 30 60 91 21 51 82 12 4 100 0 506365641 0 210850 0582770 2769610 4256730 4911290 4674820 3568440 169098 100 3 0 2289169220 0666030 3357260 554410 7031220 7685780 7449310 6342920 446546 100 60 0689802630 36450 6336230 8523071 0010191 0664751 0428280 932190 744443 100 90 3607156470 6562360 9253581 1440431 2927551 3582111 3345631 2239251 036179 101 20 6202293770 915751 1848721 4035561 5522681 6177241 5940771 4834391 295693 101 50 8243398631 119861 3889821 6076671 7563791 8218351 7981871 6875491 499803 101 80 9548145251 2503351 5194571 7381411 8868541 952311 9286621 8180241 630278 102 10 9999984491 2955191 5646411 7833251 9320381 9974931 9738461 8632081 675462 102 40 955855491 2513761 5204981 7391821 8878951 953351 9297031 8190651 631319 102 70 8263288061 1218491 3909711 6096561 7583681 8238241 8001761 6895381 501792 1030 6229886310 9185091 1876311 4063161 5550281 6204841 5968361 4861981 298452 103 30 3639987380 6595190 9286411 1473261 2960381 3614941 3378461 2272081 039462 返回 2 733 33 6 0 07899 0 36525 0 66411 0 94889 0 198463 0 0878 0 38666 0 67144 0 496360 2101 0 08877 0 37354 0 7880960 5018360 20297 0 0818 1 0476090 7613490 4624840 177709 1 251720 965460 6665940 381819 1 3821941 0959350 7970690 512294 1 4273781 1411180 8422530 557478 1 3832351 0969750 798110 513335 1 2537090 9674490 6685830 383808 1 0503690 7641090 4652430 180468 0 7913790 5051190 206253 0 07852 Participant Original Wieight Weeks in Program Weight Loss返回 Ray2851237 Pat442320 Jill240528 George2751843 Kevin29012 Joe3801815 Cindy1881313 Terry301732 Weight Loss as a Function of Weeks in Program and Original Weight 500450400350300250200150 0 5 10 15 20 25 Original Weight Lbs Weeks Weight Loss DateVolumeOpenHighLowClose返回返回 5 2712 15569 8172 6369 6970 50 5 2814 55570 9474 0070 7273 25 5 2911 98374 7575 7573 3875 63 5 3014 87774 8875 3174 1375 25 5 3116 98376 0976 3873 5074 94 High Low Close 5 275 285 295 305 31 60 64 68 72 76 80 High Low Close Open High Low Close 5 275 285 295 305 31 60 64 68 72 76 80 Open High Low Close Volume High Low Close 5 275 285 295 305 31 0 5 000 10 000 15 000 20 000 25 000 30 000 60 64 68 72 76 80 Volume High Low Close Volume Open High Low Close 5 275 285 295 305 31 0 5 000 10 000 15 000 20 000 25 000 30 000 60 64 68 72 76 80 Volume Open High Low Close Open High Low Close 5 275 285 295 305 31 60 64 68 72 76 80 Open High Low Close Volume Open High Low Close 5 275 285 295 305 31 0 5 000 10 000 15 000 20 000 25 000 30 000 60 64 68 72 76 80 Volume Open High Low Close DateVolumeOpenHighLowClose返回返回 1999 1 434 740 00069 8172 6369 6970 50 1999 1 532 110 80070 9474 0070 7273 25 1999 1 634 509 60074 7575 7573 3875 63 1999 1 725 553 80074 8875 3174 1375 25 1999 1 825 093 60076 0976 3873 5074 94 1999 1 1123 158 00075 4475 4772 9773 75 1999 1 1228 820 00074 0674 0670 5071 09 1999 1 1337 647 80068 0073 8868 0071 91 1999 1 1429 550 00072 6372 7870 7570 88 1999 1 1529 517 60071 4775 0070 6974 88 1999 1 1950 546 00075 6977 8875 4477 81 1999 1 2062 565 40083 4783 8881 2481 25 1999 1 2139 988 20080 8881 6678 8879 16 1999 1 2241 017 00077 8180 1277 6378 13 1999 1 2551 032 60080 8481 6679 0680 94 1999 1 2660 055 20082 7585 8882 2585 78 1999 1 2748 919 60086 2587 2284 2584 38 1999 1 2839 362 60085 8887 0384 9187 00 1999 1 2938 071 20087 3887 5685 4487 50 1999 2 140 553 40087 7287 9785 4186 47 1999 2 245 899 20086 2586 2883 1383 81 1999 2 336 299 60083 1984 9483 0083 41 1999 2 444 516 00084 0684 1979 4479 53 1999 2 563 972 60080 1380 8177 4480 00 1999 2 854 922 00081 2882 7880 8182 63 1999 2 938 526 00082 4783 3879 8880 03 1999 2 1036 670 80079 9482 1979 3180 31 1999 2 1129 634 20081 3881 9480 1981 38 1999 2 1231 377 80080 8481 8478 5678 88 1999 2 1636 781 60079 8880 0077 2878 13 1999 2 1750 132 80076 4777 2574 2575 00 1999 2 1858 297 60075 4775 6971 9972 88 1999 2 1936 436 20073 7274 6372 8873 84 1999 2 2245 954 80074 1376 0072 3874 50 1999 2 2347 478 60076 4779 3875 2577 72 1999 2 2433 810 20078 2279 6976 3876 44 1999 2 2535 368 80076 1976 8874 8176 75 1999 2 2629 585 40076 1976 2574 7575 06 1999 3 129 098 60074 7876 2874 7575 88 1999 3 229 168 00075 9477 0673 8174 28 1999 3 338 350 80074 5075 3473 5374 81 1999 3 430 820 60075 5676 7574 0676 13 1999 3 523 516 00077 3877 6975 6377 47 1999 3 823 067 20077 7579 8877 5079 50 1999 3 944 740 80079 9482 3879 8880 91 1999 3 1026 570 80081 1681 2579 5680 69 1999 3 1131 413 80080 5082 2879 6680 72 1999 3 1236 448 80081 3181 3878 4180 09 1999 3 1530 198 00080 2883 0078 9482 94 1999 3 1634 233 40082 7585 0082 1384 53 1999 3 1722 450 40084 5384 7283 3883 56 1999 3 1827 976 80083 2286 2883 0986 22 1999 3 1948 266 80086 9487 0684 9485 59 Microsoft Corporation 1999 2001 1 993 995 997 999 9911 991 003 005 007 009 0011 001 013 015 017 019 0111 01 0 20 40 60 80 100 120 140 160 180 200 0 20 40 60 80 100 120 1999 3 2227 695 20086 4787 4986 0086 44 1999 3 2333 956 20086 3487 0682 3483 28 1999 3 2441 106 20083 5085 9181 5685 63 1999 3 2554 627 20086 5390 0386 2589 91 1999 3 2647 076 60089 4790 1987 8889 06 1999 3 2939 397 80090 1392 6387 8892 13 1999 3 3033 720 90093 3893 5092 1993 00 1999 3 3129 367 30094 5095 0089 1389 63 1999 4 120 552 90091 2592 8889 6392 69 1999 4 519 911 80094 3197 8893 5094 94 1999 4 619 837 40095 1995 6393 2594 06 1999 4 723 455 10094 8895 0091 2593 31 1999 4 819 284 90093 2594 8091 0094 56 1999 4 915 870 30094 2598 4491 8894 25 1999 4 1219 012 90091 6393 6391 3893 00 1999 4 1323 378 10093 1393 1389 1990 13 1999 4 1426 440 40090 8191 1385 8885 88 1999 4 1536 062 40084 8889 8884 4488 88 1999 4 1622 348 50089 0689 1385 8886 44 1999 4 1937 552 40086 8888 1380 3881 00 1999 4 2053 835 10082 2584 0080 0083 13 1999 4 2146 366 40082 1383 3880 0082 00 1999 4 2227 221 80085 0085 2583 3884 94 1999 4 2328 295 70085 0087 0083 0086 00 1999 4 2624 094 80087 1988 9486 7588 00 1999 4 2729 275 20088 7588 7583 9484 00 1999 4 2828 017 70085 3186 5081 7282 13 1999 4 2930 560 20082 3883 6980 4182 06 1999 4 3029 179 00082 7584 2579 8881 31 1999 5 333 409 40081 4481 5078 5679 88 1999 5 433 236 90080 5081 8177 7578 06 1999 5 533 397 30079 1379 8876 4479 13 1999 5 637 010 50080 6981 1377 5077 94 1999 5 724 005 80079 6380 3878 0079 06 1999 5 1023 096 90079 8880 5078 2579 69 1999 5 1121 349 70080 7581 0279 0679 88 1999 5 1230 071 30080 7581 0079 2580 50 1999 5 1325 915 60081 1381 7578 8879 13 1999 5 1442 289 50078 8879 9475 5076 88 1999 5 1733 058 40077 3879 5676 8879 13 1999 5 1831 680 20079 8180 2577 9478 69 1999 5 1923 171 40079 8879 8877 0679 31 1999 5 2021 063 60079 5680 0078 3878 44 1999 5 2128 256 30078 5079 0077 0077 56 1999 5 2419 408 70077 8877 8876 0677 25 1999 5 2525 100 20076 7579 2576 1376 25 1999 5 2625 937 90077 1978 5075 5078 50 1999 5 2728 359 70078 2579 4476 1378 38 1999 5 2820 773 30078 7580 8878 1380 69 1999 6 118 008 10080 6380 7578 4478 50 1999 6 221 354 00078 0678 6376 2578 44 1999 6 316 467 20078 3878 9476 1376 38 1999 6 417 720 90076 9479 6976 7579 56 1999 6 716 244 80079 9481 0679 1980 25 1999 6 820 754 60079 8882 1379 0079 38 1999 6 926 617 50080 1383 3180 0082 31 1999 6 1017 636 00081 8882 3179 0679 88 1999 6 1117 254 80080 0080 5077 5678 13 1999 6 1414 170 60078 7579 6977 4477 56 1999 6 1518 333 40078 0678 8876 6977 69 1999 6 1624 003 10079 0681 6377 8181 00 1999 6 1722 205 90080 6983 0080 5082 88 1999 6 1835 877 30082 3185 0082 0085 00 1999 6 2127 873 60084 8889 0084 1788 94 1999 6 2219 375 50088 4488 4486 2586 50 1999 6 2316 873 70085 9487 3885 0686 00 1999 6 2418 919 30085 7586 2584 0084 63 1999 6 2512 409 50085 3887 8884 3884 94 1999 6 2815 657 20085 5086 8184 9486 75 1999 6 2919 475 90086 6988 0686 0088 00 1999 6 3027 148 60087 7590 2586 7590 06 1999 7 123 798 80089 8891 5088 2391 19 1999 7 216 067 30090 8892 1390 3192 00 1999 7 622 661 20092 2592 9489 2589 56 1999 7 716 917 30090 0692 3189 8892 31 1999 7 818 908 60091 8193 0090 6992 56 1999 7 916 868 60092 3893 3192 2593 25 1999 7 1221 473 30093 1994 7592 3894 19 1999 7 1315 359 60093 1394 3892 8193 63 1999 7 1418 917 60093 7595 0092 5094 94 1999 7 1520 411 60095 0095 2592 5094 38 1999 7 1657 539 30095 5099 8894 3899 44 1999 7 1939 989 500100 00100 7597 8198 38 1999 7 2046 085 70096 4496 7592 3193 31 1999 7 2126 966 90093 6395 3193 0094 69 1999 7 2230 441 30094 3894 5090 0091 06 1999 7 2334 388 20091 5691 7589 6990 25 1999 7 2625 588 40088 8889 8187 6387 63 1999 7 2732 733 40088 8189 7587 9288 81 1999 7 2831 079 40089 1990 5088 3890 00 1999 7 2928 759 80088 6988 8186 3186 94 1999 7 3025 066 90087 6388 6385 5085 81 1999 8 223 953 50085 6986 9484 3884 81 1999 8 327 456 90085 8886 0684 3184 75 1999 8 437 624 30085 1387 1984 7584 94 1999 8 538 308 40085 3886 3884 7585 75 1999 8 633 564 30086 0687 4484 9485 13 1999 8 919 636 00085 6385 8183 6983 81 1999 8 1031 327 10083 5685 7581 6382 94 1999 8 1132 980 40084 0084 6982 3184 19 1999 8 1230 471 00083 9484 1981 6381 75 1999 8 1332 372 40082 9485 6382 7584 69 1999 8 1628 630 00085 0685 8982 6384 31 1999 8 1725 972 00085 4485 5082 9484 56 1999 8 1829 153 60084 4486 1984 0685 00 1999 8 1935 732 90084 5685 5583 0683 81 1999 8 2023 004 90084 0084 7880 5083 38 1999 8 2330 044 60084 3186 6382 9486 44 1999 8 2460 194 20087 0693 5087 0692 19 1999 8 2540 781 40093 6396 0093 1995 31 1999 8 2630 564 60095 3896 3893 6994 63 1999 8 2720 956 20095 0695 1392 3893 25 1999 8 3016 638 10092 8893 4491 5692 25 1999 8 3123 371 80091 8193 1390 1392 56 1999 9 118 145 20092 3193 4491 6392 38 1999 9 216 528 80091 5092 5690 5091 81 1999 9 327 516 50093 7596 4491 8195 88 1999 9 723 384 20094 8896 6993 7594 25 1999 9 821 253 40093 6994 6992 0692 25 1999 9 919 232 50092 4494 1491 8094 06 1999 9 1017 159 70095 0695 9894 0095 00 1999 9 1315 057 60094 5094 8193 3893 88 1999 9 1420 094 30093 6995 5693 6395 06 1999 9 1524 164 60095 5095 7592 3892 63 1999 9 1622 946 60092 8894 0690 6393 75 1999 9 1739 731 70094 3896 5093 3896 44 1999 9 2024 023 60096 0097 8895 0097 56 1999 9 2123 512 80096 5697 2593 8194 63 1999 9 2223 988 30094 7596 6393 1996 06 1999 9 2335 644 70096 8896 8890 2591 19 1999 9 2435 133 80090 1991 3888 8890 94 1999 9 2717 068 10092 0092 9490 8891 44 1999 9 2822 971 30091 2592 6989 0692 13 1999 9 2918 466 90091 5692 1389 1389 50 1999 9 3023 229 40090 009