案例19-多重限制显示图表.xls

绘图数据 大部门2 CAO 小部门1 SubTotal JanJanFebFebMarMarAprAprMayMayJunJunJulJul 预算1567149714281378159014621491 实际1277126713781277164600 大部门列表 NS CAO COO CFO 实际 大大部部门门小小部部门门JanJanFebFebMarMarAprAprMayMayJunJunJulJul NSSubTotalSubTotal8 84 46 61 11 13 31 11 10 05 51 19 92 20 09 97 78 80 00 0 Sales228327389385277 Key Account347444318214226 ISA271360344321475 CAOSubTotalSubTotal1 12 27 77 71 12 26 67 71 13 37 78 81 12 27 77 71 16 64 46 60 00 0 Field Operation294318314350459 Customer Support325218279277275 Product Application360397394361448 Certification298334391289464 COOSubTotalSubTotal2 21 19 97 72 24 46 61 12 23 38 81 12 26 63 32 22 22 29 99 90 00 0 Manufacture218351345350416 Assembly393372499351381 Purchasing216395208317203 Planning482307321470331 Warehouse300246291490231 Maintenance279461370206244 External Logistic309329347448493 CFOSubTotalSubTotal1 18 88 87 71 14 44 44 41 19 92 24 41 18 85 59 91 14 45 51 10 00 0 Accounting379262430478219 Controlling388237456309251 Credit470316379217446 Legal403400212490214 IT247229447365321 1567 1497 1428 1378 1590 1462 1491 1680 1631 1240 1765 1277 1267 1378 1277 1646 2 20 01 12 2年年预预算算执执行行情情况况跟跟踪踪分分析析图图 J Ja a n nF Fe eb bM Ma ar rA Ap pr rM Ma a y yJ Ju u n nJ Ju ul lA Au ug gS Se ep pO Oc ct tN No o v v 0 0 2 20 00 0 4 40 00 0 6 60 00 0 8 80 00 0 1 10 00 00 0 1 12 20 00 0 1 14 40 00 0 1 16 60 00 0 1 18 80 00 0 2 20 00 00 0 预算实际 CAO选择大部选择小部 AugAugSepSepOctOctNovNov 1680163112401765 0000 预算 AugAugSepSepOctOctNovNov大大部部门门小小部部门门JanJanFebFeb 0 00 00 00 0NSSubTotalSubTotal1 10 08 89 91 11 11 16 6 Sales353488 Key Account382395 ISA354233 0 00 00 00 0CAOSubTotalSubTotal1 15 56 67 71 14 49 97 7 Field Operation347446 Customer Support394293 Product Application456353 Certification370405 0 00 00 00 0COOSubTotalSubTotal2 25 59 91 12 21 18 83 3 Manufacture436205 Assembly372255 Purchasing346378 Planning330484 Warehouse431392 Maintenance318256 External Logistic358213 0 00 00 00 0CFOSubTotalSubTotal2 21 12 21 11 16 67 75 5 Accounting439377 Controlling445250 Credit478375 Legal306455 IT453218 1567 1497 1428 1378 1590 1462 1491 1680 1631 1240 1765 1277 1267 1378 1277 1646 2 20 01 12 2年年预预算算执执行行情情况况跟跟踪踪分分析析图图 J Ja a n nF Fe eb bM Ma ar rA Ap pr rM Ma a y yJ Ju u n nJ Ju ul lA Au ug gS Se ep pO Oc ct tN No o v v 0 0 2 20 00 0 4 40 00 0 6 60 00 0 8 80 00 0 1 10 00 00 0 1 12 20 00 0 1 14 40 00 0 1 16 60 00 0 1 18 80 00 0 2 20 00 00 0 预算实际 CAO选择大部选择小部 MarMarAprAprMayMayJunJunJulJulAugAugSepSepOctOctNovNov 1 12 27 75 51 11 12 29 91 11 13 36 61 12 22 28 81 10 08 80 01 10 04 43 31 10 04 48 81 10 03 39 91 13 35 53 3 446441366493329450305245486 485208468308424305310300380 344480302427327288433494487 1 14 42 28 81 13 37 78 81 15 59 90 01 14 46 62 21 14 49 91 11 16 68 80 01 16 63 31 11 12 24 40 01 17 76 65 5 468376277400251455448258307 420383437459454370476456474 297404436233491418351209498 243215440370295437356317486 2 24 46 62 22 21 15 56 62 26 65 59 92 25 52 22 22 25 50 07 72 25 55 55 52 20 06 69 92 29 92 25 52 27 78 85 5 458262360477380343308360414 403402453397396255232402343 344237374200377440393476474 323372420241349436283401366 215395344470279419327353449 340273305325245242314466251 379215403412481420212467488 1 15 57 71 11 18 82 24 41 17 76 68 81 19 94 44 41 15 50 00 01 18 80 01 11 18