Contents
Wani manaja da ba kasafai ba a cikin aikinsa ba ya fuskantar buƙatar ganin sakamakon da aka samu idan aka kwatanta da waɗanda aka shirya da farko. A cikin kamfanoni daban-daban, na ga sigogi iri ɗaya da ake kira "Plan-Fact", "Actual vs Budget", da sauransu. Wani lokaci ana gina su kamar haka:
Rashin jin daɗin irin wannan zane shi ne cewa mai kallo ya kwatanta shirin da ginshiƙan gaskiya a cikin nau'i-nau'i, ƙoƙarin kiyaye dukan hoton a kansa, kuma tarihin tarihi a nan, a ganina, ba shine mafi kyawun zaɓi ba. Idan za mu gina irin wannan hangen nesa, to tabbas ya fi gani don amfani da zane-zane don shirin da gaskiyar. Amma sai mun fuskanci aikin na gani biyu na kwatancen maki na lokuta guda da kuma nuna bambanci tsakanin su. Bari mu gwada wasu dabaru masu amfani don wannan.
Hanyar 1. Up-saukar makada
Waɗannan su ne na gani rectangles masu haɗa bi-biyu maki na shirin da jadawali na gaskiya akan zanenmu. Bugu da ƙari, launin su ya dogara da ko mun kammala shirin ko a'a, kuma girman ya nuna nawa:
Ana haɗa irin waɗannan makada akan shafin Mai Gina - Ƙara Ƙimar Chart - Ƙungiyoyin Sama/Ƙasa (Mai ƙira - Ƙara Ma'anar Chart - Bars na sama / ƙasa) a cikin Excel 2013 ko akan tab Layout - Ci gaba-Rage Bars (Layout - Bars na sama) a cikin Excel 2007-2010. Ta hanyar tsoho za su zama baki da fari, amma kuna iya canza launin su cikin sauƙi ta danna-dama akan su kuma zaɓi umarnin Tsarin Ƙungiyoyin Sama/Ƙasa (Format Up/Down Bars). Ina bayar da shawarar sosai ta amfani da cika mai jujjuyawa, saboda. m line rufe ainihin jadawali kansu.
Abin takaici, babu wata hanya mai sauƙi da aka gina don daidaita nisa na ratsi - don haka za ku yi amfani da ɗan zamba.
- Hana zanen da aka gina
- Danna gajeriyar hanyar madannai Alt+F11don shiga Editan Kayayyakin Kayayyakin Kaya
- Danna maɓallin gajeren hanya Ctrl + Gdon buɗe shigar da umarni kai tsaye da panel debug nan da nan
- Kwafi da liƙa wannan umarni a can: ActiveChart.ChartGroups(1).GapWidth = 30 kuma latsa Shigar:
Tabbas, ana iya kunna siga (30) don samun faɗin da kuke buƙata ta gwaji.
Hanyar 2. Jadawalin da ke cike da yanki tsakanin shirin da layin gaskiya
Wannan hanyar ta ƙunshi cikar gani (zai yiwu tare da ƙyanƙyashe, alal misali) na yanki tsakanin shirin da jadawali:
Abin ban sha'awa sosai, ko ba haka ba? Mu yi kokarin aiwatar da wannan.
Da farko, ƙara wani shafi a teburin mu (bari mu kira shi, bari mu ce, Sauyi), inda muka lissafta bambanci tsakanin gaskiya da shirin a matsayin dabara:
Yanzu bari mu zaɓi ginshiƙai tare da kwanakin, tsari da bambanci a lokaci guda (riƙe Ctrl) da kuma gina zane tare da yankunan da tarawata amfani da tab Saka (Saka):
Sakamakon ya kamata a duba irin wannan:
Mataki na gaba shine zabar layuka Tsari и gaskiya, kwafa su (Ctrl + C) kuma ku ƙara zuwa zanenmu ta hanyar saka (Ctrl + V) - a cikin "sandi a cikin sashin" sabbin "yadudduka" guda biyu yakamata su bayyana a saman:
Yanzu bari mu canza nau'in ginshiƙi na waɗannan ƙarin yadudduka biyu zuwa jadawali. Don yin wannan, zaɓi kowane jere bi da bi, danna-dama akansa kuma zaɓi umarnin Canja nau'in ginshiƙi don jerin abubuwa (Canja Nau'in Chart). A cikin tsoffin sigogin Excel 2007-2010, zaku iya zaɓar nau'in ginshiƙi da ake so (Graph tare da alamomi), kuma a cikin sabon Excel 2013 akwatin maganganu zai bayyana tare da duk layuka, inda aka zaɓi nau'in da ake so don kowane jere daga jerin abubuwan da aka saukar:
Bayan danna kan OK za mu ga hoto riga kama da abin da muke bukata:
Yana da sauƙi a gane cewa ya rage kawai don zaɓar yankin shuɗi kuma canza launi mai cikawa zuwa m Babu cika (Ba Cika). To, kuma ku kawo haske na gaba ɗaya: ƙara taken, take, cire abubuwan da ba dole ba a cikin almara, da sauransu.
A ganina, wannan ya fi ginshiƙai, a'a?
- Yadda ake ƙara sabbin bayanai cikin sauri zuwa ginshiƙi ta yin kwafi
- Taswirar harsashi don nuna KPI
- Koyarwar bidiyo akan ƙirƙirar aikin Gantt ginshiƙi a cikin Excel