数据透视表,销售数据动态图表

各个销售员的销售业绩不同产品的销售成本情况,销售额和销售时间关系图,序号销售日期销售订单销售片区销售员物品编号物品型号物品名称单位单价(不含税)单个成本销售数量总价(不含税)总成本备注,43106.0dd001,43107.0dd002,43108.0dd003,43109.0dd004,43110.0dd005,6.043111.0dd006,43112.0dd007,43113.0dd008,9.043114.0dd009,10.043115.0dd010,11.043116.0dd011,12.043117.0dd012,13.043118.0dd013,14.043119.0dd014,15.043120.0dd015,16.043121.0dd016,17.043122.0dd017,18.043123.0dd018,19.043124.0dd019,20.043125.0dd020,21.043126.0dd021,22.043127.0dd022,23.043128.0dd023,24.043129.0dd024,25.043130.0dd025,26.043131.0dd026,27.043132.0dd027,28.043133.0dd028,29.043134.0dd029,30.043135.0dd030,31.043136.0dd031,32.043137.0dd032,33.043138.0dd033,34.043139.0dd034,35.043140.0dd035,36.043141.0dd036,37.043142.0dd037,38.043143.0dd038,39.043144.0dd039,40.043145.0dd040,41.043146.0dd041,42.043147.0dd042,43.043148.0dd043,44.043149.0dd044,45.043150.0dd045,46.043151.0dd046,47.043152.0dd047,48.043153.0dd048,49.043154.0dd049,50.043155.0dd050,51.043156.0dd051,52.043157.0dd052,53.043158.0dd053,54.043159.0dd054,55.043160.0dd055,56.043161.0dd056,57.043162.0dd057,58.043163.0dd058,59.043164.0dd059,60.043165.0dd060,61.043166.0dd061,62.043167.0dd062,63.043168.0dd063,64.043169.0dd064,65.043170.0dd065,66.043171.0dd066,67.043172.0dd067,68.043173.0dd068,69.043174.0dd069,70.043175.0dd070,71.043176.0dd071,72.043177.0dd072,73.043178.0dd073,74.043179.0dd074,75.043180.0dd075,76.043181.0dd076,77.043182.0dd077,78.043183.0dd078,79.043184.0dd079,80.043185.0dd080,81.043186.0dd081,82.043187.0dd082,83.043188.0dd083,84.043189.0dd084,85.043190.0dd085,86.043191.0dd086,87.043192.0dd087,88.043193.0dd088,89.043194.0dd089,90.043195.0dd090,91.043196.0dd091,92.043197.0dd092,93.043198.0dd093,94.043199.0dd094,95.043200.0dd095,96.043201.0dd096,97.043202.0dd097,98.043203.0dd098,99.043204.0dd099,100.043205.0dd100,101.043206.0dd101,102.043207.0dd102,103.043208.0dd103,104.043209.0dd104,105.043210.0dd105,106.043211.0dd106,107.043212.0dd107,108.043213.0dd108,109.043214.0dd109,110.043215.0dd110,111.043216.0dd111,112.043217.0dd112,113.043218.0dd113,114.043219.0dd114,115.043220.0dd115,116.043221.0dd116,117.043222.0dd117,118.043223.0dd118,119.043224.0dd119,120.043225.0dd120,121.043226.0dd121,122.043227.0dd122,123.043228.0dd123,124.043229.0dd124,125.043230.0dd125,126.043231.0dd126,127.043232.0dd127,128.043233.0dd128,129.043234.0dd129,130.043235.0dd130,131.043236.0dd131,132.043237.0dd132,133.043238.0dd133,134.043239.0dd134,135.043240.0dd135,136.043241.0dd136,137.043242.0dd137,138.043243.0dd138,139.043244.0dd139,140.043245.0dd140,141.043246.0dd141,142.043247.0dd142,143.043248.0dd143,144.043249.0dd144,145.043250.0dd145,146.043251.0dd146,147.043252.0dd147,148.043253.0dd148,149.043254.0dd149,150.043255.0dd150,151.043256.0dd151,152.043257.0dd152,153.043258.0dd153,154.043259.0dd154,155.043260.0dd155,156.043261.0dd156,157.043262.0dd157,158.043263.0dd158,159.043264.0dd159,160.043265.0dd160,161.043266.0dd161,162.043267.0dd162,163.043268.0dd163,164.043269.0dd164,165.043270.0dd165,166.043271.0dd166,167.043272.0dd167,168.043273.0dd168,169.043274.0dd169,170.043275.0dd170,171.043276.0dd171,172.043277.0dd172,173.043278.0dd173,174.043279.0dd174,175.043280.0dd175,176.043281.0dd176,177.043282.0dd177,178.043283.0dd178,179.043284.0dd179,180.043285.0dd180,181.043286.0dd181,182.043287.0dd182,183.043288.0dd183,184.043289.0dd184,185.043290.0dd185,186.043291.0dd186,187.043292.0dd187,188.043293.0dd188,189.043294.0dd189,190.043295.0dd190,191.043296.0dd191,192.043297.0dd192,193.043298.0dd193,194.043299.0dd194,195.043300.0dd195,196.043301.0dd196,197.043302.0dd197,198.043303.0dd198,199.043304.0dd199,200.043305.0dd200,201.043306.0dd201,202.043307.0dd202,203.043308.0dd203,204.043309.0dd204,205.043310.0dd205,206.043311.0dd206,207.043312.0dd207,208.043313.0dd208,209.043314.0dd209,210.043315.0dd210,211.043316.0dd211,212.043317.0dd212,213.043318.0dd213,214.043319.0dd214,215.043320.0dd215,216.043321.0dd216,217.043322.0dd217,218.043323.0dd218,219.043324.0dd219,220.043325.0dd220,221.043326.0dd221,222.043327.0dd222,223.043328.0dd223,224.043329.0dd224,225.043330.0dd225,226.043331.0dd226,227.043332.0dd227,228.043333.0dd228,229.043334.0dd229,230.043335.0dd230,231.043336.0dd231,232.043337.0dd232,233.043338.0dd233,234.043339.0dd234,235.043340.0dd235,236.043341.0dd236,237.043342.0dd237,238.043343.0dd238,239.043344.0dd239,240.043345.0dd240,241.043346.0dd241,242.043347.0dd242,243.043348.0dd243,244.043349.0dd244,245.043350.0dd245,246.043351.0dd246,247.043352.0dd247,248.043353.0dd248,249.043354.0dd249,250.043355.0dd250,251.043356.0dd251,252.043357.0dd252,253.043358.0dd253,254.043359.0dd254,255.043360.0dd255,256.043361.0dd256,257.043362.0dd257,258.043363.0dd258,259.043364.0dd259,260.043365.0dd260,261.043366.0dd261,262.043367.0dd262,263.043368.0dd263,264.043369.0dd264,265.043370.0dd265,266.043371.0dd266,267.043372.0dd267,268.043373.0dd268,269.043374.0dd269,270.043375.0dd270,271.043376.0dd271,272.043377.0dd272,273.043378.0dd273,274.043379.0dd274,275.043380.0dd275,276.043381.0dd276,277.043382.0dd277,278.043383.0dd278,279.043384.0dd279,280.043385.0dd280,281.043386.0dd281,282.043387.0dd282,283.043388.0dd283,284.043389.0dd284,285.043390.0dd285,286.043391.0dd286,287.043392.0dd287,288.043393.0dd288,289.043394.0dd289,290.043395.0dd290,291.043396.0dd291,292.043397.0dd292,293.043398.0dd293,294.043399.0dd294,295.043400.0dd295,296.043401.0dd296,297.043402.0dd297,298.043403.0dd298,299.043404.0dd299,43405.0dd300,301.043406.0dd301,302.043407.0dd302,303.043408.0dd303,304.043409.0dd304,305.043410.0dd305,306.043411.0dd306,307.043412.0dd307,308.043413.0dd308,309.043414.0dd309,310.043415.0dd310,311.043416.0dd311,312.043417.0dd312,313.043418.0dd313,314.043419.0dd314,315.043420.0dd315,316.043421.0dd316,317.043422.0dd317,318.043423.0dd318,319.043424.0dd319,43425.0dd320,321.043426.0dd321,322.043427.0dd322,323.043428.0dd323,324.043429.0dd324,325.043430.0dd325,326.043431.0dd326,327.043432.0dd327,328.043433.0dd328,329.043434.0dd329,330.043435.0dd330,331.043436.0dd331,332.043437.0dd332,333.043438.0dd333,334.043439.0dd334,335.043440.0dd335,336.043441.0dd336,337.043442.0dd337,338.043443.0dd338,339.043444.0dd339,340.043445.0dd340,341.043446.0dd341,342.043447.0dd342,343.043448.0dd343,344.043449.0dd344,345.043450.0dd345,346.043451.0dd346,347.043452.0dd347,348.043453.0dd348,349.043454.0dd349,350.043455.0dd350,351.043456.0dd351,352.043457.0dd352,353.043458.0dd353,354.043459.0dd354,355.043460.0dd355,356.043461.0dd356,357.043462.0dd357,358.043463.0dd358,359.043464.0dd359,360.043465.0dd360,361.043466.0dd361,362.043467.0dd362,363.043468.0dd363,364.043469.0dd364,365.043470.0dd365,366.043471.0dd366,367.043472.0dd367,368.043473.0dd368,369.043474.0dd369,370.043475.0dd370,371.043476.0dd371,372.043477.0dd372,373.043478.0dd373,374.043479.0dd374,375.043480.0dd375,376.043481.0dd376,377.043482.0dd377,378.043483.0dd378,379.043484.0dd379,380.043485.0dd380,381.043486.0dd381,382.043487.0dd382,383.043488.0dd383,384.043489.0dd384,385.043490.0dd385,386.043491.0dd386,387.043492.0dd387,388.043493.0dd388,389.043494.0dd389,390.043495.0dd390,391.043496.0dd391,392.043497.0dd392,393.043498.0dd393,394.043499.0dd394,395.043500.0dd395,396.043501.0dd396,397.043502.0dd397,398.043503.0dd398,399.043504.0dd399,43505.0dd400,401.043506.0dd401,402.043507.0dd402,403.043508.0dd403,404.043509.0dd404,405.043510.0dd405,406.043511.0dd406,407.043512.0dd407,408.043513.0dd408,409.043514.0dd409,410.043515.0dd410,411.043516.0dd411,412.043517.0dd412,413.043518.0dd413,414.043519.0dd414,415.043520.0dd415,416.043521.0dd416,417.043522.0dd417,418.043523.0dd418,419.043524.0dd419,420.043525.0dd420,421.043526.0dd421,422.043527.0dd422,423.043528.0dd423,424.043529.0dd424,425.043530.0dd425,426.043531.0dd426,427.043532.0dd427,428.043533.0dd428,429.043534.0dd429,430.043535.0dd430,431.043536.0dd431,432.043537.0dd432,433.043538.0dd433,434.043539.0dd434,435.043540.0dd435,436.043541.0dd436,437.043542.0dd437,438.043543.0dd438,439.043544.0dd439,440.043545.0dd440,441.043546.0dd441,442.043547.0dd442,443.043548.0dd443,444.043549.0dd444,445.043550.0dd445,446.043551.0dd446,447.043552.0dd447,448.043553.0dd448,449.043554.0dd449,43555.0dd450,451.043556.0dd451,452.043557.0dd452,453.043558.0dd453,454.043559.0dd454,455.043560.0dd455,456.043561.0dd456,457.043562.0dd457,458.043563.0dd458,459.043564.0dd459,460.043565.0dd460,461.043566.0dd461,462.043567.0dd462,463.043568.0dd463,464.043569.0dd464,465.043570.0dd465,466.043571.0dd466,467.043572.0dd467,468.043573.0dd468,469.043574.0dd469,470.043575.0dd470,471.043576.0dd471,472.043577.0dd472,473.043578.0dd473,474.043579.0dd474,475.043580.0dd475,476.043581.0dd476,477.043582.0dd477,478.043583.0dd478,479.043584.0dd479,480.043585.0dd480,481.043586.0dd481,482.043587.0dd482,483.043588.0dd483,484.043589.0dd484,485.043590.0dd485,486.043591.0dd486,487.043592.0dd487,488.043593.0dd488,489.043594.0dd489,490.043595.0dd490,491.043596.0dd491,492.043597.0dd492,493.043598.0dd493,494.043599.0dd494,495.043600.0dd495,496.043601.0dd496,497.043602.0dd497,498.043603.0dd498,499.043604.0dd499,43605.0dd500,501.043606.0dd501,502.043607.0dd502,503.043608.0dd503,504.043609.0dd504,505.043610.0dd505,506.043611.0dd506,507.043612.0dd507,508.043613.0dd508,509.043614.0dd509,510.043615.0dd510,511.043616.0dd511,512.043617.0dd512,513.043618.0dd513,514.043619.0dd514,515.043620.0dd515,516.043621.0dd516,517.043622.0dd517,518.043623.0dd518,519.043624.0dd519,520.043625.0dd520,521.043626.0dd521,522.043627.0dd522,523.043628.0dd523,524.043629.0dd524,525.043630.0dd525,526.043631.0dd526,527.043632.0dd527,528.043633.0dd528,529.043634.0dd529,530.043635.0dd530,531.043636.0dd531,532.043637.0dd532,533.043638.0dd533,534.043639.0dd534,535.043640.0dd535,536.043641.0dd536,537.043642.0dd537,538.043643.0dd538,539.043644.0dd539,540.043645.0dd540,541.043646.0dd541,542.043647.0dd542,543.043648.0dd543,544.043649.0dd544,545.043650.0dd545,546.043651.0dd546,547.043652.0dd547,548.043653.0dd548,549.043654.0dd549,550.043655.0dd550,551.043656.0dd551,552.043657.0dd552,553.043658.0dd553,554.043659.0dd554,555.043660.0dd555,556.043661.0dd556,557.043662.0dd557,558.043663.0dd558,559.043664.0dd559,560.043665.0dd560,561.043666.0dd561,562.043667.0dd562,563.043668.0dd563,564.043669.0dd564,565.043670.0dd565,566.043671.0dd566,567.043672.0dd567,568.043673.0dd568,569.043674.0dd569,570.043675.0dd570,571.043676.0dd571,572.043677.0dd572,573.043678.0dd573,574.043679.0dd574,575.043680.0dd575,576.043681.0dd576,577.043682.0dd577,578.043683.0dd578,579.043684.0dd579,580.043685.0dd580,581.043686.0dd581,行标签求和项:总价(不含税),二区417600.0,小花213550.0,小鹏204050.0,三区636600.0,小胖219750.0,小曲207400.0,小鱼209450.0,一区432700.0,小李216700.0,小张216000.0,总计1486900.0,行标签求和项:总价(不含税),2018年971950.0,第一季251100.0,1月75500.0,2月86200.0,3月89400.0,第二季262100.0,4月83800.0,5月90800.0,6月87500.0,第三季232550.0,7月86600.0,8月74500.0,9月71450.0,第四季226200.0,10月77950.0,11月78150.0,12月70100.0,2019年514950.0,第一季211400.0,1月74750.0,2月64650.0,3月72000.0,第二季210400.0,4月69000.0,5月74700.0,6月66700.0,第三季93150.0,7月73250.0,8月19900.0,总计1486900.0,行标签求和项:总价(不含税)求和项:总成本,名称1585100.0346880.0,名称2680900.0390260.0,名称3220900.0149560.0,总计1486900.0886700.0,使用说明,1.源数据可以按照表头放到销售记录里面;,2.sheet1,sheet2.sheet3分别是数据透视表,可以选择右击"刷新"刷新数据,3.图表区,是根据三个透视表生成的,可以随之变化,4.图表区的第一行,可以进行选择时间和片区,根据选择,图表会随之变化,5.使用过程中有问题可以联系qq2423664812,仅限于改表格的问题咨询