Okuqukethwe
Uma uvamise ukwakha imibiko ngezinkomba zezimali (i-KPI) ku-Excel, kufanele uthanda lolu hlobo lweshadi olungavamile - ishadi lesikali noma ishadi le-thermometer (Ishadi Lechashazi):
- Umugqa obomvu ovundlile ubonisa inani eliqondiwe esihlose ukulithola.
- Ukugcwaliswa kwengemuva lemibala emithathu kwesikali kukhombisa ngokusobala izindawo "ezimbi-maphakathi-ezinhle" lapho sifika khona.
- Unxande omnyama omaphakathi ubonisa inani lamanje lepharamitha.
Yebo, awekho amanani wangaphambilini wepharamitha kumdwebo onjalo, okungukuthi, Ngeke sibone noma yimaphi ama-dynamics noma amathrendi, kodwa ukuze kuboniswe ngokucacile imiphumela ezuziwe uma iqhathaniswa nemigomo okwamanje, ifaneleka impela.
Ividiyo
Isiteji 1. I-histogram estakiwe
Kuzodingeka siqale ngokwakha i-histogram evamile esekelwe kudatha yethu, esizoyiletha efomini esilidingayo ngezinyathelo ezimbalwa. Khetha idatha yomthombo, vula ithebhu Faka bese ukhetha i-histogram estakiwe:
Manje sengeza:
- Ukwenza amakholomu angahambi ngokulandelana, kodwa phezu kwelinye, shintshanisa imigqa namakholomu usebenzisa inkinobho. Umugqa/Ikholomu (Umugqa/Ikholomu) ithebhu Umakhi (Umklamo).
- Sisusa inganekwane kanye negama (uma likhona) - sine-minimalism lapha.
- Lungisa ukugcwaliswa kombala wamakholomu ngokwencazelo yawo (wakhethe ngamunye ngamunye, chofoza kwesokudla kwekhethiwe bese ukhetha Ifomethi yephoyinti ledatha).
- Ukunciphisa ishadi ngobubanzi
Okukhipha kufanele kubheke into enjengale:
Isiteji 2. I-eksisi yesibili
Khetha umugqa Value (unxande omnyama), vula izindawo zayo ngenhlanganisela Ctrl + 1 noma chofoza kwesokudla kukho - Ifomethi Yomugqa (Iphoyinti Ledatha Yefomethi) futhi efasiteleni lamapharamitha shintshela umugqa I-axiliary axis (i-eksisi yesibili).
Ikholomu emnyama izohambisana ne-eksisi yesibili bese iqala ukumboza bonke abanye onxande abanemibala – ungesabi, yonke into ihambisana nohlelo 😉 Ukuze ubone isikali, nyusele I-side clearance (Igebe) kuze kufike ekugcineni ukuze uthole isithombe esifanayo:
Sekufudumele, akunjalo?
Isigaba 3. Zibekele umgomo
Khetha umugqa Injongo (unxande obomvu), chofoza kwesokudla kuso, khetha umyalo Shintsha uhlobo lweshadi lochungechunge bese ushintsha uhlobo lube Ichashazi (Scatter). Unxande obomvu kufanele uguquke ube umaka owodwa (oyindilinga noma omise okuka-L), okungukuthi:
Ngaphandle kokukhipha okukhethiwe kuleli phuzu, kuvule kona Amaphutha Amabha ithebhu Isakhiwo. noma kuthebhu umakhi (ku-Excel 2013). Izinguqulo zakamuva ze-Excel zinikeza izinketho ezimbalwa zale migoqo - zihlole uma ufisa:
Kusukela endaweni yethu, "amadevu" kufanele ahluke kuzo zonke izinkomba ezine - ngokuvamile asetshenziselwa ukubonisa ukubekezelelana kokunemba noma ukusabalalisa (ukuhlakazeka) kwamanani, isibonelo, ngezibalo, kodwa manje siwasebenzisa ngenjongo ye-prosaic eyengeziwe. Susa amabha amile (khetha bese ucindezela inkinobho Susa), bese ulungisa ezivundlile ngokuchofoza kwesokudla kuzo bese ukhetha umyalo Ibha Yephutha Yefomethi:
Efasiteleni lezindawo lemigoqo evundlile yamaphutha esigabeni Inani lephutha Khetha inani elingashintshi or Ngokwezifiso (Custom) futhi usethe inani elihle nelibi lephutha kusuka kukhibhodi elilingana no-0,2 - 0,5 (ekhethwe ngeso). Lapha ungakwazi futhi ukwandisa ukushuba kwebha futhi ushintshe umbala wayo ube bomvu. Umaka ungacishwa. Ngenxa yalokho, kufanele kube kanje:
Isiteji 4. Ukuqeda ukuthinta
Manje kuzoba nomlingo. Buka izandla zakho: khetha i-eksisi eyengeziwe efanele bese ucindezela Susa kukhibhodi. Wonke amakholomu ethu esikali esakhiwe, ibha yephutha eqondiwe kanye nonxande omnyama oyinhloko yenani lamanje lepharamitha kwehliswa kusistimu eyodwa yokuxhumanisa futhi iqala ukuklanywa nge-eksisi eyodwa:
Yilokho kuphela, umdwebo usulungile. Enhle, akunjalo? 🙂
Kungenzeka ukuthi uzoba namapharamitha ambalwa ofuna ukuwabonisa usebenzisa amashadi anjalo. Ukuze ungaphindi yonke i-saga ngokwakhiwa, ungavele ukopishe ishadi, bese (ukulikhetha) uhudule unxande oluhlaza okwesibhakabhaka wendawo yedatha yomthombo kumanani amasha:
- Ungalakha kanjani ishadi lePareto ku-Excel
- Ulakha kanjani ishadi lempophoma lokuphambuka (“impophoma” noma “ibhuloho”) ku-Excel
- Yini Okusha Kumashadi ku-Excel 2013