Excel表格模板：年中销售统计报表.xlsx

《Excel表格模板：年中销售统计报表.xlsx》由会员分享，可在线阅读，更多相关《Excel表格模板：年中销售统计报表.xlsx（16页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、60%40%各各部部门门人人数数对对比比图图销售1部销售2部67%33%各各部部门门销销量量对对比比图图销售1部销售2部11021107739505125091004112386月月份份销销量量对对比比图图12345602000400060008000100001200014000Series1Series2员工销量对比分析图张1张2张3张4张5张6张7张8张9张10张11张12张13张14张15张16张17张18张19张200.00%1.00%2.00%3.00%4.00%5.00%6.00%7.00%8.00%0%10%20%30%40%50%60%70%80%90%100%年中销售报表6

2、0%40%各各部部门门人人数数对对比比图图销售1部销售2部67%33%各各部部门门销销量量对对比比图图销售1部销售2部11021107739505125091004112386月月份份销销量量对对比比图图12345602000400060008000100001200014000Series1Series260%40%各各部部门门人人数数对对比比图图销售1部销售2部67%33%各各部部门门销销量量对对比比图图销售1部销售2部11021107739505125091004112386月月份份销销量量对对比比图图12345602000400060008000100001200014000Serie

3、s1Series2员工销量对比分析图张1张2张3张4张5张6张7张8张9张10张11张12张13张14张15张16张17张18张19张200.00%1.00%2.00%3.00%4.00%5.00%6.00%7.00%8.00%0%10%20%30%40%50%60%70%80%90%100%年中销售报表60%40%各各部部门门人人数数对对比比图图销售1部销售2部67%33%各各部部门门销销量量对对比比图图销售1部销售2部11021107739505125091004112386月月份份销销量量对对比比图图12345602000400060008000100001200014000Series

4、1Series260%40%各各部部门门人人数数对对比比图图销售1部销售2部67%33%各各部部门门销销量量对对比比图图销售1部销售2部11021107739505125091004112386月月份份销销量量对对比比图图12345602000400060008000100001200014000Series1Series2员工销量对比分析图张1张2张3张4张5张6张7张8张9张10张11张12张13张14张15张16张17张18张19张200.00%1.00%2.00%3.00%4.00%5.00%6.00%7.00%8.00%0%10%20%30%40%50%60%70%80%90%100

5、%60%40%各各部部门门人人数数对对比比图图销售1部销售2部67%33%各各部部门门销销量量对对比比图图销售1部销售2部11021107739505125091004112386月月份份销销量量对对比比图图12345602000400060008000100001200014000Series1Series2年年中中销销售售报报表表一一、部部门门月月数数汇汇总总分分析析表表部门人数一月二月三月四月五月销售1部1269887797639076507709销售2部840332976311548592332二二、分分月月销销售售明明细细表表销销售售合合计计110211102110773107739

6、5059505125091250910041100411238612386编编号号姓姓名名部部门门一一月月二二月月三三月月四四月月五五月月六六月月DK0001张1销售1部527875894699562885DK0002张2销售1部714648996772343855DK0003张3销售1部445602651607981898DK0004张4销售1部124746678467854964DK0005张5销售1部862921523542150794DK0006张6销售1部755970173874551373DK0007张7销售1部783918222652990121DK0008张8销售1部89128

7、5695349520830DK0009张9销售1部673547431468572865DK0010张10销售1部441533606993413163DK0011张11销售1部473612234515990320DK0012张12销售1部300140287712783845DK0013张13销售2部723168544599420521DK0014张14销售2部777408363288462640DK0015张15销售2部111278585849176929DK0016张16销售2部515691161547244648DK0017张17销售2部821326304755164378DK0018张18

8、销售2部304676198344413724DK0019张19销售2部495304199908216330DK0020张20销售2部287125761569237303六月合计7913444474473217886623566235总总销销售售额额排排名名百百分分比比排排名名444216.71%432826.53%418436.32%383345.79%379255.73%369665.58%368675.57%357085.39%355695.37%3149104.75%3144114.75%3067124.63%2975134.49%2938144.44%2928154.42%280616

9、4.24%2748174.15%2659184.01%2452193.70%2282203.45%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0

10、.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%