Shafin yana ba ku damar iya gani da hangen nesa da bayanai kan wasu alamomi, ko kuma ƙarfin aikinsu. Ana amfani da Charts duka a cikin aikin kimiyya ko na bincike, da cikin gabatarwa. Bari mu kalli yadda ake gina zane a Microsoft Excel.
Shiryawa
Kuna iya zana hoto a cikin Microsoft Excel kawai bayan tebur tare da bayanan da ke shirye, akan abin da za a gina shi.
Bayan teburin ya shirya, kasancewa a cikin "Saka" tab, zaɓi yankin tebur inda bayanan lissafin da muke so mu gani a cikin jren. Sannan, a kan kintinkiri cikin akwatunan ayyukan Charts, danna maɓallin Chart.
Bayan haka, jerin suna buɗe, wanda aka gabatar da nau'ikan zane-zane guda bakwai:
- jadawalin yau da kullun;
- tare da tarawa;
- tsari na yau da kullun tare da tarawa;
- tare da alamomi;
- ginshiƙi tare da alamomi da tara kaya;
- al'ada ginshiƙi tare da alamomi da tarawa;
- jadawalin volumetric.
Mun zaɓi jadawalin wanda, a ra'ayin ku, ya fi dacewa da takamaiman maƙasudin ginin sa.
Bayan haka, aikin Microsoft Excel na aiwatar da shirin kai tsaye.
Gyara zane
Bayan an gina jadawalin, zaku iya shirya shi don bashi bayyanar da za'a iya gabatarwa, kuma domin sauƙaƙe fahimtar kayan da wannan jadawalin yake nunawa.
Domin alamar sunan ginshiƙi, je zuwa shafin "Layout" na maye mai hoton ginshiƙi. Danna maɓallin a kan kintinkiri a ƙarƙashin sunan "Chart Name". A jeri wanda zai buɗe, zaɓi inda za'a sanya sunan: a tsakiya ko sama da jadawalin. Zaɓi na biyu shine yafi dacewa, don haka danna kan kayan "Sama da ginshiƙi". Bayan haka, suna ya bayyana wanda za a iya maye gurbinsa ko a canza shi a hankali, kawai ta danna shi kuma shigar da haruffan da ake so daga keyboard.
Domin yin suna na zanin hoto, danna maɓallin "Axis Name". A cikin jerin abubuwan da aka aika, kai tsaye zaɓi abu "Sunan babban ginin kwance", sannan kaje zuwa matsayin "Suna ƙarƙashin ƙarƙashin layi".
Bayan haka, wani nau'i don sunan ya bayyana a ƙarƙashin aksarin, inda zaku iya shigar da kowane irin sunan da kuke so.
Hakanan, muna sa hannu a kan madaidaiciya. Latsa maɓallin "sunan Sunan", amma a cikin menu wanda ya bayyana, zaɓi sunan "Sunan babban layi na tsaye." Bayan haka, jerin zaɓuɓɓukan wurin sanya hannu uku ya buɗe:
- juya
- a tsaye
- a kwance.
Zai fi kyau a yi amfani da sunan jujjuyawar, kamar yadda a wannan yanayin, ana ajiye sarari a takardar. Danna sunan "Sunan juyawa".
Kuma a kan takardar kusa da axis mai dacewa, filin yana nuna inda zaku iya shigar da sunan gatarin da ya fi dacewa da mahallin bayanan.
Idan kuna tunanin ba a buƙatar almara don fahimtar jadawalin ba, kuma yana ɗaukar sarari kawai, to, zaku iya share shi. Don yin wannan, danna maɓallin "Legend" wanda ke kan kintinkiri kuma zaɓi "A'a". Zaka iya zaɓar kowane matsayi na almara idan ba kwa son share shi, amma canza wuri kawai.
Yin shiryawa tare da wani karin taimako
Akwai lokuta idan kuna buƙatar sanya jadaloli da yawa akan jirgin saman. Idan suna da kalifa guda ɗaya, to ana yin wannan daidai daidai kamar yadda aka bayyana a sama. Amma idan matakan suka bambanta?
Da farko, kasancewa a cikin "Saka" tab, azaman na ƙarshe, zaɓi ƙimar teburin. Bayan haka, danna maɓallin "Chart", sannan zaɓi zaɓin jadawalin da yafi dacewa.
Kamar yadda kake gani, zane biyu ne. Don nuna daidai sunan ɓangaren ma'auni don kowane jeri, muna danna-dama akan wanda zamu ƙara ƙari akan abu. A cikin menu wanda ya bayyana, zaɓi abu "Jerin bayanan jerin".
Tsarin jerin bayanan bayanai yana farawa. A cikin sashinsa “Sigogi na jere”, wanda ya kamata ya buɗe ta hanyar tsoho, za mu canza makun zuwa matsayin "A kan ma'aunin na biyu". Latsa maɓallin "rufe".
Bayan haka, ana ƙirƙirar sabon akin, kuma ana sake gina jeri.
Yanzu, ya zama dole mu sa hannu a kan gatari, da sunan zane, ta amfani da daidaitattun hanyoyin iri ɗaya kamar na farkon abin da ya gabata. Idan akwai zane-zane da yawa, zai fi kyau kar a cire almara.
Yin zane mai zane
Yanzu bari mu gano yadda za'a tsara jadawali don aikin da aka bayar.
A ce muna da aiki y = x ^ 2-2. Mataki zai zama 2.
Da farko dai, muna gina tebur. A gefen hagu, cika abubuwan x a cikin yawan 2, i.e. 2, 4, 6, 8, 10, da dai sauransu. A sashin dama muna tuƙa cikin tsari.
Bayan haka, muna isa zuwa ga kusurwar dama ta sel, danna tare da maɓallin linzamin kwamfuta, da kuma “shimfiɗa” zuwa ƙasan tebur ɗin, daga nan sai kwafin dabara ya shiga sauran sel.
To, je zuwa "Saka" tab. Mun zaɓi bayanan abin da ke aiki, sannan danna maɓallin "Maɓallin yaudara" a kan kintinkiri. Daga jerin jadawalin da aka gabatar, zamu zabi jigon ma'ana tare da muryoyi masu santsi da alamomi, tunda wannan ra'ayin ya fi dacewa don gina aiki.
Shirya jadawainiyar aiki.
Bayan an gina jadawalin, zaku iya share labarin, kuma kuyi wasu canje-canje na gani, waɗanda aka riga aka tattauna a sama.
Kamar yadda kake gani, Microsoft Excel yana ba da ikon gina nau'ikan zane-zane daban-daban. Babban yanayin wannan shine ƙirƙirar tebur tare da bayanai. Bayan an kirkiro jadawalin, ana iya canza shi kuma a daidaita shi daidai da niyyar da aka nufa.
