管理利劍之EXCEL 07 經(jīng)典圖表

1、序序號(hào)號(hào)工工作作表表名名稱稱1目目錄錄21-柱柱形形圖圖32-條條形形圖圖43-拆拆線線圖圖153-拆拆線線圖圖263-拆拆線線圖圖374-餅餅圖圖184-餅餅圖圖295-XY散散點(diǎn)點(diǎn)圖圖1105-XY散散點(diǎn)點(diǎn)圖圖2116-面面積積圖圖127-圓圓環(huán)環(huán)圖圖138-雷雷達(dá)達(dá)圖圖1148-雷雷達(dá)達(dá)圖圖2159-曲曲面面圖圖1610-氣氣泡泡圖圖1711-股股價(jià)價(jià)圖圖11811-股股價(jià)價(jià)圖圖21911-股股價(jià)價(jià)圖圖32012-圓圓柱柱、圓圓錐錐、棱棱錐錐圖圖2113-甘甘特特圖圖2214-單單點(diǎn)點(diǎn)圖圖2315-自自動(dòng)動(dòng)更更新新2416-比比較較柱柱狀狀2517-流流程程圖圖2618-波波士士頓頓矩矩

2、陣陣2719-直直方方和和正正態(tài)態(tài)圖圖12819-直直方方和和正正態(tài)態(tài)圖圖22920-WBS返回YearWidgets Sprockets199760,98364,983199856,73268,981199949,83177,398200043,32388,091200139,87993,73319971998199920002001010,00020,00030,00040,00050,00060,00070,00080,00090,000100,000WidgetsSprockets19971998199920002001020,00040,00060,00080,000100,0001

3、20,000140,000160,000SprocketsWidgets199719981999200020010%10%20%30%40%50%60%70%80%90%100%SprocketsWidgets100,00090,00080,00070,00060,00050,00040,00030,00020,00010,000019971998199920002001WidgetsSprocketsWidgetsSprockets100,00090,00080,00070,00060,00050,00040,00030,00020,00010,00001997199819992000200

4、1WidgetsSprocketsWidgetsSprockets19971998199920002001010,00020,00030,00040,00050,00060,00070,00080,00090,000100,000WidgetsSprockets19971998199920002001020,00040,00060,00080,000100,000120,000140,000160,000SprocketsWidgets199719981999200020010%10%20%30%40%50%60%70%80%90%100%SprocketsWidgets100,00090,0

5、0080,00070,00060,00050,00040,00030,00020,00010,000019971998199920002001WidgetsSprocketsWidgetsSprockets100,00090,00080,00070,00060,00050,00040,00030,00020,00010,000019971998199920002001WidgetsSprocketsWidgetsSprocketsItemStronglyAgreeAgreeUndecidedDisagreeStronglyDisagree返回Store locations are conven

6、ient12%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,

7、 I am satisfied6%28%24%25%17%I would recommend your company3%9%20%27%41%Percent Who Strongly AgreeStore locations are convenientStore hours are convenientStores are well-maintainedI like your web siteEmployees are friendlyYou have a good selection of productsI like your TV adsYou sell quality produc

8、tsOverall, I am satisfiedI would recommend your company30%25%20%15%10%5%0%Survey ResultsStore locations are convenientStore hours are convenientStores are well-maintainedI like your web siteEmployees are friendlyYou have a good selection of productsI like your TV adsYou sell quality productsOverall,

9、 I am satisfiedI would recommend your company100%80%60%40%20%0%StronglyAgreeAgreeUndecidedDisagreeStronglyDisagreeSurvey ResultsStore locations are convenientStore hours are convenientStores are well-maintainedI like your web siteEmployees are friendlyYou have a good selection of productsI like your

10、 TV adsYou sell quality productsOverall, I am satisfiedI would recommend your company100%80%60%40%20%0%StronglyAgreeAgreeUndecidedDisagreeStronglyDisagree19,874返回19,38220,06421,02622,17822,11021,92621,40521,73321,26721,52321,86521,21021,40221,61020,69920,96220,19519,59219,69919,61718,59917,482返回17,5

11、4917,97018,61819,19419,71220,45019,46220,67720,83421,33921,50721,13321,63621,65922,23422,50421,90221,99521,72322,00821,66621,77122,97023,23622,98322,18321,75722,03922,17522,88223,183Daily Sales1112131415161718191101111121 131 141 151 161171 181 19112,00017,00022,00027,00032,00037,00022,46122,57822,4

12、0421,82821,85322,14021,88721,36921,08720,30620,25719,99619,60919,42220,00119,93720,36820,95921,80921,79523,14523,69623,66623,84124,32225,07324,80824,86924,71924,45724,65124,92624,11524,13623,48523,36024,14023,94724,08224,71024,62223,99523,63823,97923,81123,88422,97223,54022,65321,58221,22621,37322,0

13、0222,25523,26824,31523,68223,25523,93624,43824,36325,36024,41323,83824,31824,64824,04624,02122,94723,09123,23423,31223,88723,26222,57222,89723,64923,73922,97123,37422,80323,75123,74823,79723,61623,69023,13523,93624,38024,32425,17225,39125,36725,17926,05926,48826,42626,68027,14926,75126,76027,19727,4

14、9727,66127,87827,85227,96127,73928,04227,16927,45427,81628,64828,50628,41529,26830,14029,52629,59129,37930,31030,35131,71531,73931,83232,72233,25432,30231,57130,96930,84632,09832,18932,95433,91933,67033,05534,39635,09934,06434,64334,81134,16534,47733,91433,837Daily Sales1112131415161718191101111121

15、131 141 151 161171 181 19112,00017,00022,00027,00032,00037,000National R&D expenditures, by source of funds: 19532000返回返回IndustryFederalOther195343.553.92.5195442.355.22.6195540.257.42.5195639.458.62.1195735.062.92.1195834.063.92.1195932.565.42.1196032.965.02.0196132.765.12.2196232.864.82.419633

16、1.166.52.4196430.866.82.4196532.365.22.5196633.264.22.6196734.962.42.7196836.560.72.8196938.558.62.9197039.857.03.2197140.256.43.4197240.855.83.4197343.053.63.4197444.651.83.6197544.452.03.7197644.951.53.7197745.251.03.7197846.050.23.8197947.149.23.7198048.947.53.7198149.746.73.6198250.346.13.619835

17、0.346.23.6198451.045.53.5198550.546.03.5198650.745.53.9198749.646.44.1198850.844.94.3198952.842.64.6199054.740.64.7199157.437.84.8199258.236.85.0199358.336.55.2199458.635.95.5199560.434.35.3199662.532.15.3199764.230.55.4199865.229.55.4199966.927.75.3200068.426.35.3National R&D Expenditures, By S

18、ource of Funds19531957196119651969197319771981198519891993199701020304050607080IndustryFederalOtherNational R&D Expenditures, By Source of Funds19531957196119651969197319771981198519891993199701020304050607080IndustryFederalOtherPopulation Projections (in thousands)返回California OregonWashington1

19、99531,5893,1415,431200032,5213,3975,858200534,4413,6136,258201541,3733,9927,058202549,2854,3497,80850,00045,00040,00035,00030,00025,00020,00015,00010,0005,000019952000200520152025CaliforniaOregonWashingtonPopulation Growth返回Excel 2002554Excel 20001082Excel 97554Excel 95255Other version98返回Excel 2002

20、Excel 2000Excel 97Excel 95Other versionExcel Usage at XYX CorporationCategoryAmount返回返回Rent12,909,288Supplies3,221,904Miscellaneous2,981,448Region 1 Salary7,832,288Region 2 Salary1,959,768Region 3 Salary3,983,233Region 4 Salary2,887,309SalaryRentSuppliesMiscellaneousRegion 1 SalaryRegion 2 SalaryReg

21、ion 3 SalaryRegion 4 SalaryCurrent Year Expenses5-XY散點(diǎn)圖1Page 18YearMonthCallsSales返回2000 Jan90489Feb89589Mar89689Apr88186May90992Jun86486Jul90791Aug89391Sep87586Oct91188Nov92293Dec840912001 Jan90991Feb89789Mar88587Apr85682May82581Jun81577Jul79976Aug81385Sep78876Oct77775Nov78677Dec79897返回Relationship

22、 Between Outbound SalesCallsAnd Sales Made (24-Month Period)940920900880860840820800780760740720700707580859095100Outbound Sales Calls in the MonthSales Made in the Month5-XY散點(diǎn)圖1Page 19Relationship Between Outbound SalesCallsAnd Sales Made (24-Month Period)9409209008808608408208007807607407207007075

23、80859095100Outbound Sales Calls in the MonthSales Made in the MonthXY返回23636823返回109876543210012345678910返回Product A Product B Product CQtr-1544933564Qtr-2705902455Qtr-33541,243233Qtr-4812545565返回Quarterly Sales, by ProductQtr-1Qtr-2Qtr-3Qtr-402505007501,0001,2501,5001,7502,0002,250Product CProduct

24、BProduct A1,4001,2001,0008006004002000Qtr-1Qtr-2Qtr-3Qtr-4Product AProduct BProduct CQuarterly Sales, by ProductQuarterly Sales, by ProductQtr-1Qtr-2Qtr-3Qtr-402505007501,0001,2501,5001,7502,0002,250Product CProduct BProduct A1,4001,2001,0008006004002000Qtr-1Qtr-2Qtr-3Qtr-4Product AProduct BProduct

25、CQuarterly Sales, by ProductSales by State返回1st Half2nd HalfCalifornia21,704,71417,987,034Oregon8,774,09912,214,447Washington12,094,21510,873,099Total42,573,02841,074,580返回51%21%28%44%30%26%Sales Breakdown, by StateCaliforniaOregonWashington1st Half2nd HalfSales Breakdown, by State1st Half2nd Half0%

26、10%20%30%40%50%60%70%80%90%100%WashingtonOregonCalifornia51%21%28%44%30%26%Sales Breakdown, by StateCaliforniaOregonWashington1st Half2nd HalfSales Breakdown, by State1st Half2nd Half0%10%20%30%40%50%60%70%80%90%100%WashingtonOregonCalifornia返回RedGreenBlue返回Color-112825564Color-23333255Color-3128128

27、128Color-422255255Note: 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-1RedGreenBlue555105155205255Color-2RedGreenBlue555105155205255Color-3RedGreenBlue555105155205255Color-4RedGre

28、enBlue555105155205255返回Snow Ski SalesWater Ski SalesJan6,8971,983Feb7,7325,547Mar4,5007,330Apr3,1229,832May89310,739Jun73416,453Jul89115,874Aug5599,833Sep5,4334,312Oct8,7344,433Nov11,8737,545Dec18,7309,832返回JanFebMarAprMayJunJulAugSepOctNovDecSnow Ski SalesWater Ski SalesJanFebMarAprMayJunJulAugSepO

29、ctNovDecSnow Ski SalesWater Ski Sales返回00.30.60.91.21.51.82.12.4100 -0.506365641-0.210850.0582770.2769610.4256730.4911290.4674820.3568440.169098100.3 -0.2289169220.0666030.3357260.554410.7031220.7685780.7449310.6342920.446546100.60.0689802630.36450.6336230.8523071.0010191.0664751.0428280.932190.7444

30、43100.90.3607156470.6562360.9253581.1440431.2927551.3582111.3345631.2239251.036179101.20.6202293770.915751.1848721.4035561.5522681.6177241.5940771.4834391.295693101.50.8243398631.119861.3889821.6076671.7563791.8218351.7981871.6875491.499803101.80.9548145251.2503351.5194571.7381411.8868541.952311.928

31、6621.8180241.630278102.10.9999984491.2955191.5646411.7833251.9320381.9974931.9738461.8632081.675462102.40.955855491.2513761.5204981.7391821.8878951.953351.9297031.8190651.631319102.70.8263288061.1218491.3909711.6096561.7583681.8238241.8001761.6895381.5017921030.6229886310.9185091.1876311.4063161.555

32、0281.6204841.5968361.4861981.298452103.30.3639987380.6595190.9286411.1473261.2960381.3614941.3378461.2272081.039462返回2.733.33.6-0.07899-0.36525-0.66411-0.948890.198463-0.0878-0.38666-0.671440.496360.2101-0.08877-0.373540.7880960.5018360.20297-0.08181.0476090.7613490.4624840.1777091.251720.965460.666

33、5940.3818191.3821941.0959350.7970690.5122941.4273781.1411180.8422530.5574781.3832351.0969750.798110.5133351.2537090.9674490.6685830.3838081.0503690.7641090.4652430.1804680.7913790.5051190.206253-0.07852ParticipantOriginalWieightWeeks inProgramWeightLoss返回Ray2851237Pat442320Jill240528George2751843Kev

34、in29012Joe3801815Cindy1881313Terry301732Weight Loss as a Function of Weeks in Program and Original Weight 5004504003503002502001500510152025Original Weight (Lbs)WeeksWeightLossDateVolumeOpenHighLowClose返回返回5/2712,15569.8172.6369.6970.505/2814,55570.9474.0070.7273.255/2911,98374.7575.7573.3875.635/30

35、14,87774.8875.3174.1375.255/3116,98376.0976.3873.5074.94High-Low-Close5/275/285/295/305/31606468727680HighLowCloseOpen-High-Low-Close5/275/285/295/305/31606468727680OpenHighLowCloseVolume High-Low-Close5/275/285/295/305/3105,00010,00015,00020,00025,00030,000606468727680VolumeHighLowCloseVolume-Open-

36、High-Low-Close5/275/285/295/305/3105,00010,00015,00020,00025,00030,000606468727680VolumeOpenHighLowCloseOpen-High-Low-Close5/275/285/295/305/31606468727680OpenHighLowCloseVolume-Open-High-Low-Close5/275/285/295/305/3105,00010,00015,00020,00025,00030,000606468727680VolumeOpenHighLowCloseDateVolumeOpe

37、nHighLowClose返回返回1999/1/434,740,00069.8172.6369.6970.501999/1/532,110,80070.9474.0070.7273.251999/1/634,509,60074.7575.7573.3875.631999/1/725,553,80074.8875.3174.1375.251999/1/825,093,60076.0976.3873.5074.941999/1/1123,158,00075.4475.4772.9773.751999/1/1228,820,00074.0674.0670.5071.091999/1/1337,647

38、,80068.0073.8868.0071.911999/1/1429,550,00072.6372.7870.7570.881999/1/1529,517,60071.4775.0070.6974.881999/1/1950,546,00075.6977.8875.4477.811999/1/2062,565,40083.4783.8881.2481.251999/1/2139,988,20080.8881.6678.8879.161999/1/2241,017,00077.8180.1277.6378.131999/1/2551,032,60080.8481.6679.0680.94199

39、9/1/2660,055,20082.7585.8882.2585.781999/1/2748,919,60086.2587.2284.2584.381999/1/2839,362,60085.8887.0384.9187.001999/1/2938,071,20087.3887.5685.4487.501999/2/140,553,40087.7287.9785.4186.471999/2/245,899,20086.2586.2883.1383.811999/2/336,299,60083.1984.9483.0083.411999/2/444,516,00084.0684.1979.44

40、79.531999/2/563,972,60080.1380.8177.4480.001999/2/854,922,00081.2882.7880.8182.631999/2/938,526,00082.4783.3879.8880.031999/2/1036,670,80079.9482.1979.3180.311999/2/1129,634,20081.3881.9480.1981.381999/2/1231,377,80080.8481.8478.5678.881999/2/1636,781,60079.8880.0077.2878.131999/2/1750,132,80076.477

41、7.2574.2575.001999/2/1858,297,60075.4775.6971.9972.881999/2/1936,436,20073.7274.6372.8873.841999/2/2245,954,80074.1376.0072.3874.501999/2/2347,478,60076.4779.3875.2577.721999/2/2433,810,20078.2279.6976.3876.441999/2/2535,368,80076.1976.8874.8176.751999/2/2629,585,40076.1976.2574.7575.061999/3/129,09

42、8,60074.7876.2874.7575.881999/3/229,168,00075.9477.0673.8174.281999/3/338,350,80074.5075.3473.5374.811999/3/430,820,60075.5676.7574.0676.131999/3/523,516,00077.3877.6975.6377.471999/3/823,067,20077.7579.8877.5079.501999/3/944,740,80079.9482.3879.8880.911999/3/1026,570,80081.1681.2579.5680.691999/3/1

43、131,413,80080.5082.2879.6680.721999/3/1236,448,80081.3181.3878.4180.091999/3/1530,198,00080.2883.0078.9482.941999/3/1634,233,40082.7585.0082.1384.531999/3/1722,450,40084.5384.7283.3883.561999/3/1827,976,80083.2286.2883.0986.221999/3/1948,266,80086.9487.0684.9485.59Microsoft Corporation: 1999-20011/9

44、93/995/997/999/9911/991/003/005/007/009/0011/001/013/015/017/019/0111/01020406080100120140160180200$0$20$40$60$80$100$1201999/3/2227,695,20086.4787.4986.0086.441999/3/2333,956,20086.3487.0682.3483.281999/3/2441,106,20083.5085.9181.5685.631999/3/2554,627,20086.5390.0386.2589.911999/3/2647,076,60089.4

45、790.1987.8889.061999/3/2939,397,80090.1392.6387.8892.131999/3/3033,720,90093.3893.5092.1993.001999/3/3129,367,30094.5095.0089.1389.631999/4/120,552,90091.2592.8889.6392.691999/4/519,911,80094.3197.8893.5094.941999/4/619,837,40095.1995.6393.2594.061999/4/723,455,10094.8895.0091.2593.311999/4/819,284,

46、90093.2594.8091.0094.561999/4/915,870,30094.2598.4491.8894.251999/4/1219,012,90091.6393.6391.3893.001999/4/1323,378,10093.1393.1389.1990.131999/4/1426,440,40090.8191.1385.8885.881999/4/1536,062,40084.8889.8884.4488.881999/4/1622,348,50089.0689.1385.8886.441999/4/1937,552,40086.8888.1380.3881.001999/

47、4/2053,835,10082.2584.0080.0083.131999/4/2146,366,40082.1383.3880.0082.001999/4/2227,221,80085.0085.2583.3884.941999/4/2328,295,70085.0087.0083.0086.001999/4/2624,094,80087.1988.9486.7588.001999/4/2729,275,20088.7588.7583.9484.001999/4/2828,017,70085.3186.5081.7282.131999/4/2930,560,20082.3883.6980.

48、4182.061999/4/3029,179,00082.7584.2579.8881.311999/5/333,409,40081.4481.5078.5679.881999/5/433,236,90080.5081.8177.7578.061999/5/533,397,30079.1379.8876.4479.131999/5/637,010,50080.6981.1377.5077.941999/5/724,005,80079.6380.3878.0079.061999/5/1023,096,90079.8880.5078.2579.691999/5/1121,349,70080.758

49、1.0279.0679.881999/5/1230,071,30080.7581.0079.2580.501999/5/1325,915,60081.1381.7578.8879.131999/5/1442,289,50078.8879.9475.5076.881999/5/1733,058,40077.3879.5676.8879.131999/5/1831,680,20079.8180.2577.9478.691999/5/1923,171,40079.8879.8877.0679.311999/5/2021,063,60079.5680.0078.3878.441999/5/2128,2

50、56,30078.5079.0077.0077.561999/5/2419,408,70077.8877.8876.0677.251999/5/2525,100,20076.7579.2576.1376.251999/5/2625,937,90077.1978.5075.5078.501999/5/2728,359,70078.2579.4476.1378.381999/5/2820,773,30078.7580.8878.1380.691999/6/118,008,10080.6380.7578.4478.501999/6/221,354,00078.0678.6376.2578.44199

51、9/6/316,467,20078.3878.9476.1376.381999/6/417,720,90076.9479.6976.7579.561999/6/716,244,80079.9481.0679.1980.251999/6/820,754,60079.8882.1379.0079.381999/6/926,617,50080.1383.3180.0082.311999/6/1017,636,00081.8882.3179.0679.881999/6/1117,254,80080.0080.5077.5678.131999/6/1414,170,60078.7579.6977.447

52、7.561999/6/1518,333,40078.0678.8876.6977.691999/6/1624,003,10079.0681.6377.8181.001999/6/1722,205,90080.6983.0080.5082.881999/6/1835,877,30082.3185.0082.0085.001999/6/2127,873,60084.8889.0084.1788.941999/6/2219,375,50088.4488.4486.2586.501999/6/2316,873,70085.9487.3885.0686.001999/6/2418,919,30085.7

53、586.2584.0084.631999/6/2512,409,50085.3887.8884.3884.941999/6/2815,657,20085.5086.8184.9486.751999/6/2919,475,90086.6988.0686.0088.001999/6/3027,148,60087.7590.2586.7590.061999/7/123,798,80089.8891.5088.2391.191999/7/216,067,30090.8892.1390.3192.001999/7/622,661,20092.2592.9489.2589.561999/7/716,917

54、,30090.0692.3189.8892.311999/7/818,908,60091.8193.0090.6992.561999/7/916,868,60092.3893.3192.2593.251999/7/1221,473,30093.1994.7592.3894.191999/7/1315,359,60093.1394.3892.8193.631999/7/1418,917,60093.7595.0092.5094.941999/7/1520,411,60095.0095.2592.5094.381999/7/1657,539,30095.5099.8894.3899.441999/

55、7/1939,989,500100.00100.7597.8198.381999/7/2046,085,70096.4496.7592.3193.311999/7/2126,966,90093.6395.3193.0094.691999/7/2230,441,30094.3894.5090.0091.061999/7/2334,388,20091.5691.7589.6990.251999/7/2625,588,40088.8889.8187.6387.631999/7/2732,733,40088.8189.7587.9288.811999/7/2831,079,40089.1990.508

56、8.3890.001999/7/2928,759,80088.6988.8186.3186.941999/7/3025,066,90087.6388.6385.5085.811999/8/223,953,50085.6986.9484.3884.811999/8/327,456,90085.8886.0684.3184.751999/8/437,624,30085.1387.1984.7584.941999/8/538,308,40085.3886.3884.7585.751999/8/633,564,30086.0687.4484.9485.131999/8/919,636,00085.63

57、85.8183.6983.811999/8/1031,327,10083.5685.7581.6382.941999/8/1132,980,40084.0084.6982.3184.191999/8/1230,471,00083.9484.1981.6381.751999/8/1332,372,40082.9485.6382.7584.691999/8/1628,630,00085.0685.8982.6384.311999/8/1725,972,00085.4485.5082.9484.561999/8/1829,153,60084.4486.1984.0685.001999/8/1935,

58、732,90084.5685.5583.0683.811999/8/2023,004,90084.0084.7880.5083.381999/8/2330,044,60084.3186.6382.9486.441999/8/2460,194,20087.0693.5087.0692.191999/8/2540,781,40093.6396.0093.1995.311999/8/2630,564,60095.3896.3893.6994.631999/8/2720,956,20095.0695.1392.3893.251999/8/3016,638,10092.8893.4491.5692.25

59、1999/8/3123,371,80091.8193.1390.1392.561999/9/118,145,20092.3193.4491.6392.381999/9/216,528,80091.5092.5690.5091.811999/9/327,516,50093.7596.4491.8195.881999/9/723,384,20094.8896.6993.7594.251999/9/821,253,40093.6994.6992.0692.251999/9/919,232,50092.4494.1491.8094.061999/9/1017,159,70095.0695.9894.0

60、095.001999/9/1315,057,60094.5094.8193.3893.881999/9/1420,094,30093.6995.5693.6395.061999/9/1524,164,60095.5095.7592.3892.631999/9/1622,946,60092.8894.0690.6393.751999/9/1739,731,70094.3896.5093.3896.441999/9/2024,023,60096.0097.8895.0097.561999/9/2123,512,80096.5697.2593.8194.631999/9/2223,988,30094.7596.6393.