Chithunzi "Plan-Fact"

Woyang'anira wosowa muzochita zake samakumana ndi kufunikira kowonera zotsatira zomwe zapezedwa poyerekeza ndi zomwe zidakonzedweratu. M'makampani osiyanasiyana, ndawonapo ma chart ambiri ofanana omwe amatchedwa "Plan-Fact", "Actual vs Budget", ndi zina zotero. Nthawi zina amamangidwa motere:

Kusokonezeka kwa chithunzi choterocho ndi chakuti wowonera ayenera kufananitsa ndondomeko ndi mizati yeniyeni mwa awiriawiri, kuyesera kusunga chithunzi chonse pamutu pake, ndipo histogram apa, mwa lingaliro langa, si njira yabwino kwambiri. Ngati tikufuna kupanga zowonera zotere, ndiye kuti ndizowoneka bwino kwambiri kugwiritsa ntchito ma graph pamalingaliro ndi zenizeni. Koma ndiye tikuyang'anizana ndi ntchito yofananiza mfundo za nthawi zomwezo ndikuwonetsa kusiyana pakati pawo. Tiyeni tiyese njira zothandiza za izi.

Njira 1. Magulu okwera-pansi

Awa ndi ma rectangles owoneka omwe amalumikizana pawiri mfundo za pulani ndi ma graph enieni pazithunzi zathu. Komanso, mtundu wawo umadalira ngati tamaliza dongosolo kapena ayi, ndipo kukula kukuwonetsa kuchuluka kwake:

Magulu oterowo akuphatikizidwa pa tabu Womanga - Onjezani Chigawo cha Tchati - Magulu Okwera / Pansi (Kupanga - Onjezani Chart Element - Mipiringidzo Yokwera / Pansi) mu Excel 2013 kapena pa tabu Kamangidwe - Mipiringidzo Yochepetsera Patsogolo (Masanjidwe - Mipiringidzo Yokwera Pansi) mu Excel 2007-2010. Mwachikhazikitso adzakhala akuda ndi oyera, koma mutha kusintha mtundu wawo mosavuta ndikudina kumanja ndikusankha lamulo. Mapangidwe a Magulu Okwera / Pansi (Mawonekedwe Okwera/Otsika). Ndikupangira kugwiritsa ntchito translucent fill, chifukwa. mzere wolimba umatseka ma graph oyambirira okha.

Tsoka ilo, palibe njira yosavuta yopangidwira yosinthira kukula kwa mikwingwirima - chifukwa cha izi muyenera kugwiritsa ntchito chinyengo chaching'ono.

1. Onetsani chithunzi chomangidwa
2. Dinani njira yachidule ya kiyibodi Alt + F11kuti mulowe mu Visual Basic Editor
3. Dinani njira yomasulira Ctrl + Gkuti mutsegule zolowetsa zachindunji ndi gulu lowongolera mwamsanga
4. Koperani ndi kumata lamulo ili pansipa: ActiveChart.ChartGroups(1).GapWidth = 30 Ndi kukanikiza Lowani:

Zachidziwikire, parameter (30) imatha kuseweredwa mozungulira kuti mupeze m'lifupi momwe mungayesere.

Njira 2. Tchati chokhala ndi kudzaza madera pakati pa ndondomeko ndi mfundo

Njirayi imaphatikizapo kudzaza kowonekera (ndizotheka ndi kuswa, mwachitsanzo) kwa dera lapakati pa dongosolo ndi ma graph enieni:

Zochititsa chidwi, sichoncho? Tiyeni tiyesetse kukhazikitsa izi.

Choyamba, onjezani gawo lina patebulo lathu (tiyeni titchule, tinene, Kusiyana), pomwe timawerengera kusiyana pakati pa chowonadi ndi dongosolo ngati chilinganizo:

Tsopano tiyeni tisankhe mizati yokhala ndi masiku, mapulani ndi kusiyana nthawi imodzi (kugwira Ctrl) ndi kupanga chithunzi ndi madera ndi kudzikundikirapogwiritsa ntchito tabu Ikani (Ikani):

Zotsatirazi ziyenera kuoneka ngati izi:

Chotsatira ndikusankha mizere Plan и Ndipotu, koperani (Ctrl + C) ndikuwonjezera pazithunzi zathu poyika (Ctrl + V) - mu "sangweji yathu mu gawo" "zigawo" ziwiri zatsopano ziyenera kuwonekera pamwamba:

Tsopano tiyeni tisinthe mtundu wa tchati wa zigawo ziwiri zowonjezeredwazi kukhala graph. Kuti muchite izi, sankhani mzere uliwonse motsatana, dinani pomwepa ndikusankha lamulo Sinthani mtundu wa tchati kukhala mndandanda (Sintha Mtundu wa Chart Series). M'mitundu yakale ya Excel 2007-2010, mutha kusankha mtundu womwe mukufuna (Grafu yokhala ndi zolembera), ndipo mu Excel 2013 yatsopano bokosi la zokambirana lidzawoneka ndi mizere yonse, pomwe mtundu womwe ukufunidwa umasankhidwa pamzere uliwonse kuchokera pamndandanda wotsikira pansi:

Pambuyo pang'anani OK tiwona chithunzi chofanana kale ndi chomwe tikufuna:

N'zosavuta kudziwa kuti zimangokhala kusankha malo abuluu ndikusintha mtundu wake wodzaza kuti ukhale woonekera Palibe kudzaza (Palibe Kudzaza). Chabwino, ndi kubweretsa kuwala zonse: onjezani mawu, mutu, kuchotsa zinthu zosafunikira mu nthano, etc.

M'malingaliro anga, izi ndizabwino kwambiri kuposa mizati, sichoncho?

• Momwe mungawonjezere mwachangu deta yatsopano ku tchati pokopera
• Bullet chart yowonetsa KPI
• Maphunziro a kanema pakupanga tchati cha Gantt mu Excel