Okuqukethwe
Umphathi ongavamile ekusebenzeni kwakhe akabhekene nesidingo sokubona ngeso lengqondo imiphumela ezuziwe uma iqhathaniswa naleyo eyayihlelwe ekuqaleni. Ezinkampanini ezihlukene, ngibone amashadi amaningi afanayo abizwa ngokuthi “Plan-Iqiniso”, “Okwangempela vs Budget”, njll. Kwesinye isikhathi akhiwa kanje:
Ukuphazamiseka komdwebo onjalo ukuthi umbukeli kufanele aqhathanise uhlelo namakholomu eqiniso ngamabili, ezama ukugcina isithombe sonke ekhanda lakhe, futhi i-histogram lapha, ngombono wami, akuyona inketho engcono kakhulu. Uma sizokwakha umbono onjalo, khona-ke kubonakala kuthe xaxa ukusebenzisa amagrafu ohlelweni kanye neqiniso. Kodwa-ke sibhekene nomsebenzi wokuqhathanisa okubonakalayo ngakubili kwamaphuzu ezikhathi ezifanayo nokugqamisa umehluko phakathi kwawo. Ake sizame amasu awusizo alokhu.
Indlela 1. Amabhendi abheke phansi
Lawa ama-rectangles abonakalayo axhuma ngamapheya amaphuzu ohlelo kanye namagrafu eqiniso kumdwebo wethu. Ngaphezu kwalokho, umbala wabo uncike ekutheni siqedile uhlelo noma cha, futhi usayizi ubonisa ukuthi malini:
Amabhendi anjalo afakiwe kuthebhu Umakhi – Engeza Isici Seshadi – Amabhendi Aphezulu/Aphansi (Idizayini - Engeza isici Seshadi - Amabha aphezulu/aphansi) ku-Excel 2013 noma kuthebhu Isakhiwo – Amabha Okwehliswa Okuthuthukile (Isakhiwo - Amabha Aphezulu-Phansi) ku-Excel 2007-2010. Ngokuzenzakalelayo zizoba mnyama nezimhlophe, kodwa ungakwazi ukushintsha umbala wazo kalula ngokuchofoza kwesokudla kuzo bese ukhetha umyalo. Ifomethi yamabhendi aphezulu/aphansi (Fometha Amabha Aphezulu/Phansi). Ngincoma kakhulu ukusebenzisa i-translucent fill, ngoba. umugqa oqinile uvala amagrafu okuqala ngokwawo.
Ngeshwa, ayikho indlela elula eyakhelwe ngaphakathi yokulungisa ububanzi bemigqa - kulokhu kuzodingeka usebenzise iqhinga elincane.
- Gqamisa umdwebo owakhiwe
- Cindezela isinqamuleli sekhibhodi I-Alt + F11ukuze ungene ku-Visual Basic Editor
- Cindezela isinqamuleli sekhibhodi I-Ctrl + Gukuze uvule okokufaka komyalo oqondile kanye nephaneli yokususa iphutha ngokushesha
- Kopisha bese unamathisele umyalo olandelayo lapho: I-ActiveChart.ChartGroups(1).GapWidth = 30 bese ucindezela Faka:
Kunjalo, ipharamitha (30) ingadlalwa nxazonke ukuze uthole ububanzi obudingayo ngokuhlola.
Indlela 2. Ishadi eligcwaliswa indawo phakathi kwepulani nemigqa yamaqiniso
Le ndlela ibandakanya ukugcwaliswa okubonakalayo (kungenzeka ngokuchanyuselwa, isibonelo) kwendawo ephakathi kwepulani namagrafu eqiniso:
Kuyamangaza impela, akunjalo? Ake sizame ukwenza lokhu.
Okokuqala, engeza enye ikholomu etafuleni lethu (asiyibize, ake sithi, Umehluko), lapho sibala khona umehluko phakathi kweqiniso nohlelo njengefomula:
Manje ake sikhethe amakholomu anezinsuku, ipulani kanye nomehluko ngesikhathi esisodwa (ubambe Ctrl) bese wakhe umdwebo ngezindawo ezinqwabeleneusebenzisa ithebhu Faka (Faka):
Okukhipha kufanele kubheke into enjengale:
Isinyathelo esilandelayo ukukhetha imigqa Plan и Iqiniso, zikopishe (Ctrl + C) bese wengeza kumdwebo wethu ngokufaka (Ctrl + V) - "kwisandwich esigabeni" kufanele kuvele "izendlalelo" ezimbili ezintsha phezulu:
Manje ake sishintshe uhlobo lweshadi lwalezi zendlalelo ezimbili ezingeziwe lube igrafu. Ukuze wenze lokhu, khetha umugqa ngamunye ngokulandelana, chofoza kwesokudla kuwo bese ukhetha umyalo Shintsha uhlobo lweshadi lochungechunge (Shintsha Uhlobo Lweshadi Lochungechunge). Ezinguqulweni ezindala ze-Excel 2007-2010, ungakhetha uhlobo lweshadi olifunayo (Igrafu enamaka), futhi ku-Excel 2013 entsha kuzovela ibhokisi lengxoxo nayo yonke imigqa, lapho uhlobo olufunayo lukhethwa kumugqa ngamunye ohlwini lokudonsela phansi:
Ngemuva kokuchofoza OK sizobona isithombe esivele sifana nesikudingayo:
Kulula ukuthola ukuthi kusala kuphela ukukhetha indawo eluhlaza okwesibhakabhaka futhi uguqule umbala wayo wokugcwalisa ube osobala Akukho ukugcwaliswa (Akukho Gcwalisa). Hhayi-ke, futhi ulethe ukukhanya okuvamile: engeza amagama-ncazo, isihloko, susa izinto ezingadingekile kunganekwane, njll.
Ngokubona kwami, lokhu kungcono kakhulu kunamakholomu, akunjalo?
- Ungayengeza kanjani ngokushesha idatha entsha eshadini ngokukopisha
- Ishadi lechashazi lokubonisa i-KPI
- Isifundo sevidiyo sokwenza ishadi lephrojekthi ye-Gantt ku-Excel