Tsarin Microsoft Excel na Microsoft yana ba da damar ba kawai don yin aiki tare da bayanan lambobi ba, har ma yana samar da kayan aikin don ƙirƙirar zane-zane bisa ga tsarin shigar. A lokaci guda, yanayin kallon su na iya zama daban. Bari mu ga yadda za a zana nau'ikan zane-zane ta amfani da Microsoft Excel.
Yarda tebur
Gina nau'ikan zane daban-daban zane ne babu bambanci. Kawai a wani matakin kana buƙatar zaɓi nau'in hangen nesa da ya dace.
Kafin ka fara ƙirƙirar kowane ginshiƙi, kana buƙatar gina tebur tare da bayanai akan abin da za a gina shi. To, je zuwa "Saka" tab, kuma zaɓi yankin na wannan tebur, wanda za a bayyana a cikin zane.
A kan kintinkiri a cikin "Saka" tab, zaɓi ɗaya daga nau'ikan zane guda uku:
- Histogram;
- Jadawalin;
- Madauwari;
- Doka;
- Tare da yankuna;
- Batu.
Bugu da ƙari, ta danna maɓallin "Sauran", zaku iya zaɓar ƙananan nau'ikan zane-zanen ƙasa: jari, ƙasa, zobe, kumfa, fure.
Bayan haka, ta danna kowane nau'in zane, ana ba da shawara don zaɓar takamaiman tallafin. Misali, don tarihin tarihi, ko tambarin mashaya, abubuwanda zasu iya kasancewa zasu kasance masu wannan tallafin: histogram talakawa, volumetric, sililin, conical, pyramidal.
Bayan zaɓar takamaiman tallafin, ana ƙirƙirar zane ta atomatik. Misali, dattigram na yau da kullun zai yi kama da wanda aka nuna a hoton da ke ƙasa.
Shafin jadawali zai yi kama da wannan.
Tsarin yanki zai yi kama da wannan.
Aiki tare da ginshiƙi
Bayan an ƙirƙiri ginshiƙi, a cikin sabon shafin "Aiki tare da Charts" ƙarin kayan aikin don gyara da canza shi ya zama akwai. Kuna iya canza nau'in ginshiƙi, salon sa, da sauran sigogi masu yawa.
Shafin "Aiki tare da Charts" yana da ƙarin ƙarin ƙananan ƙananan ƙananan abubuwa guda uku: "Design", "Layout" da "Tsarin".
Don suna ginshiƙi, je zuwa "Layout" tab, kuma zaɓi ɗaya daga cikin zaɓuɓɓuka don wurin sunan: a tsakiya ko sama da ginshiƙi.
Bayan an gama wannan, daidaitaccen taken “Chart Name” ya bayyana. Canza shi zuwa kowane rubutu wanda ya dace da yanayin wannan tebur.
An sanya sunayen bangarorin kamar yadda aka tsara su a daidai wannan hanyar, amma saboda wannan akwai buƙatar danna maɓallin "Alamomin Suna".
Nunin Chart kashi na ɗari
Don nuna yawan alamomin daban-daban, ya fi kyau a gina keɓaɓɓen alamomin keɓe.
Kamar yadda muka yi a sama, mun gina tebur, sannan zaɓi ɓangaren da ake so. Bayan haka, je zuwa "Saka" tab, zabi kek din ginshiƙi a kan kintinkiri, sannan kuma, a cikin jerin da ya bayyana, danna kan kowane nau'in tambarin kek.
Bugu da ari, shirin kai tsaye ya dauke mu zuwa daya daga cikin shafuka don aiki tare da zane-zane - "Mai tsara". Daga cikin shimfidar zane a cikin kintinkiri, zabi kowane wanda ke da alamar kashi.
Pie ginshiƙi nuna kashi shirye shirye.
Pareto charting
Dangane da ka’idar Wilfredo Pareto, 20% daga cikin ayyuka mafi inganci suna kawo 80% na sakamakon gaba daya. Dangane da haka, ragowar kashi 80% na yawan ayyukan da basu da inganci, suna kawo 20% ne kawai na sakamakon. Ginin Pareto zane shine kawai don ƙididdige ayyukan mafi inganci waɗanda ke ba da iyakar dawowa. Za mu yi wannan ta amfani da Microsoft Excel.
Zai fi dacewa mu gina hoton Pareto ta hanyar tsarin tarihi, wanda muka riga muka tattauna a sama.
Misalin gini. Tebur yana ba da jerin kayan abinci. A cikin shafi ɗaya, farashin siye na duk girman nau'in samfurin iri ɗaya a kantin sayar da kayayyaki, an shiga cikin na biyu, ribar daga siyarwarsa. Dole ne mu tantance waɗanne samfura suke bayarwa mafi girma '' dawo '' kan siyarwa.
Da farko dai, muna gina ma'aunin tarihi. Je zuwa "Saka" tab, zaɓi duka nau'in ƙimar tebur, danna maɓallin "Histogram", kuma zaɓi nau'in tarihin da ake so.
Kamar yadda kake gani, a sakamakon waɗannan ayyukan, an tsara zane tare da nau'ikan ginshiƙai guda biyu: shuɗi da ja.
Yanzu, muna buƙatar canza layin jan zuwa zane. Don yin wannan, zaɓi waɗannan ginshiƙai tare da siginan kwamfuta, kuma a cikin "Design" shafin, danna maɓallin "Canjin nau'in ginshiƙi".
Ana buɗe yanayin sauya nau'in ginshiƙi. Je zuwa "Chart" sashe, kuma zaɓi nau'in ginshiƙi da ya dace da manufar mu.
Don haka, ana gina hoton Pareto. Yanzu, zaku iya shirya abubuwan da ke ciki (sunan ginshiƙi da gatari, suttura, da dai sauransu), kamar yadda aka bayyana ta amfani da misalin kwalin mashaya.
Kamar yadda kake gani, Microsoft Excel yana samar da kayan aiki da yawa don ginawa da gyara nau'ikan zane-zane daban-daban. Gabaɗaya, aikin tare da waɗannan kayan aikin yana sauƙaƙe sauƙaƙe ta masu haɓaka ta yadda masu amfani da matakan horo daban-daban zasu iya jure su.
