Yadda ake juya ginshiƙi a cikin Excel

Wannan labarin yayi magana game da yadda ake juya ginshiƙi a cikin Excel 2010-2013. Za ku koyi hanyoyi daban-daban don juya mashaya, mashaya, kek da sigogin layi, gami da nau'ikan su na 3D. Hakanan za ku ga yadda ake canza tsarin ginin ƙima, rukunoni, jeri, da almara. Ga waɗanda ke yawan buga jadawali da taswira, koyi yadda ake saita madaidaicin takarda don bugawa.

Excel yana da sauƙin gabatar da tebur azaman ginshiƙi ko jadawali. Don yin wannan, kawai zaɓi bayanan kuma danna gunkin nau'in ginshiƙi mai dacewa. Koyaya, saitunan tsoho bazai dace ba. Idan kuna son jujjuya ginshiƙi a cikin Excel don shirya yankan kek, ginshiƙai, ko layi daban, to wannan labarin naku ne.

• Juya ginshiƙi kek a cikin Excel zuwa kusurwar da ake so
• Juya 3D Graphs a cikin Excel: Juya Pie, Bar da Bar Charts
• Juya Chart 180°: Sake yin oda Ƙungiyoyi, Ƙimar, da Jerin Bayanai
  
  • Canza odar Gina Rukunin Gina a cikin Chart na Excel
  • Canza oda na Ƙimar Gina
  • Juya tsarin tsararrun bayanai akan ginshiƙi na 3D
  • Canja matsayi na almara akan ginshiƙi
• Canza jadawalin takardar don mafi dacewa da ginshiƙi
• Amfani da Kayan Aikin Kyamara don Juya Chart na Excel zuwa Kusurwar Sabani

Juya ginshiƙi kek a cikin Excel zuwa kusurwar da ake so

Idan sau da yawa kuna buƙatar nuna girman dangi a cikin rabbai, to yana da kyau a yi amfani da sigogin kek. A cikin hoton da ke ƙasa, alamun bayanan sun mamaye taken, don haka ginshiƙi ya yi kama da ban tsoro. Ina so in kwafi wannan ginshiƙi cikin gabatarwar PowerPoint game da al'adun dafa abinci na mutane, kuma ina buƙatar ginshiƙi ya kasance mai kyau. Don samun aikin da kuma haskaka sashin mafi mahimmanci, kuna buƙatar sanin yadda ake juya taswirar kek a cikin Excel agogon agogo.

1. Danna-dama akan kowane yanki na ginshiƙi na kek ɗin kuma daga menu wanda ya bayyana, zaɓi Tsarin bayanai (Format Data Series).
2. Kwamitin suna ɗaya zai bayyana. A cikin filin Matsakaicin jujjuyawar sashin farko (Kusurwar yanki na farko), maimakon sifili, shigar da ƙimar kusurwar juyawa a digiri kuma latsa Shigar. Ina tsammanin jujjuyawar digiri na 190 zai yi don ginshiƙi na kek.

Bayan juyawa, ginshiƙi a cikin Excel yayi kyau sosai:

Don haka, ba shi da wahala a juya taswirar Excel zuwa kowane kusurwa don ba shi yanayin da ake so. Hanyar tana da amfani duka don daidaita wurin da alamun bayanai da kuma nuna mahimman sassa.

Juya 3D Graphs a cikin Excel: Juya Pie, Bar da Bar Charts

Ina tsammanin ginshiƙan 3D suna da kyau sosai. Lokacin da wasu mutane suka ga hoton XNUMXD, sun tabbata cewa mahaliccinsa ya san duk hanyoyin da ake gani a cikin Excel. Idan jadawali da aka ƙirƙira tare da saitunan tsoho bai yi kama da yadda kuke so ba, kuna iya daidaita shi ta hanyar juyawa da canza saitunan hangen nesa.

1. Danna-dama akan ginshiƙi kuma zaɓi daga menu wanda ya bayyana. Juyawa XNUMXD (Juyawa 3-D).
2. Wani panel zai bayyana Tsarin Yanki na Chart (Yankin Tsarin Tsarin Tsarin). A cikin filayen Juyawa a kusa da axis X (X Rotation) da Juyawa kewaye da axis Y (Y Juyawa) Shigar da adadin digirin da ake so don juyawa.Na saita dabi'u zuwa 40 ° da 35 ° bi da bi don ba da zurfin tunani na.

Hakanan zaka iya saita zaɓuɓɓuka a cikin wannan rukunin. Zurfin (zurfin), Height (tsawo) da Hangen zaman gaba (Hanyoyin). Gwada don nemo mafi kyawun saituna don jadawalin ku. Hakazalika, zaku iya saita ginshiƙi na kek.

Juya Chart 180°: Sake yin oda Ƙungiyoyi, Ƙimar, ko Jerin Bayanai

Idan ginshiƙi da kuke son juyawa a cikin Excel yana nuni da gatura a kwance da a tsaye, zaku iya canza tsari cikin sauƙi ko ƙimar da aka ƙulla tare da waɗannan gatura. Bugu da ƙari, a cikin filaye na 3D waɗanda ke da axis mai zurfi, za ku iya canza tsarin da aka tsara jerin bayanai don kada manyan sanduna na 3D su zo kan ƙananan. A cikin Excel, zaku iya canza matsayin almara akan ginshiƙi ko taswirar mashaya.

Canja tsari na nau'ikan gini a cikin zane

Ana iya jujjuya ginshiƙi game da axis a kwance (axis na rukuni).

1. Danna dama akan axis a kwance kuma daga menu wanda ya bayyana zaɓi Tsarin Axis (Format Axis).
2. Kwamitin suna ɗaya zai bayyana. Don juya ginshiƙi 180°, kawai duba akwatin Juya tsari na rukunoni (Cegories a baya domin).

Canja tsarin ƙima a cikin ginshiƙi

Ta bin waɗannan matakai masu sauƙi, zaku iya jujjuya ginshiƙi a kusa da axis na tsaye.

1. Dama danna kan axis a tsaye (darajar axis) kuma zaɓi Tsarin Axis (Format Axis).
2. Duba akwatin Juya tsarin dabi'u (Dabi'u a cikin tsari na baya).

lura: Ka tuna cewa ba zai yiwu a canza tsarin da aka ƙirƙira ƙididdiga a cikin taswirar radar ba.

Juya tsarin tsararrun bayanai a cikin ginshiƙi na 3D

Idan ginshiƙi na mashaya ko mashaya yana da axis na uku, tare da wasu sanduna a gaba wasu kuma a baya, za ku iya canza tsarin da aka tsara jerin bayanai ta yadda manyan abubuwan 3D ba su zo kan ƙananan ƙananan ba. Yin amfani da matakai masu zuwa, za a iya ƙirƙira filaye biyu ko fiye don nuna duk jerin daga almara.

1. Danna-dama akan axis jerin ƙimar (Z-axis) a cikin ginshiƙi kuma a cikin menu da ya bayyana, danna Tsarin Axis (Format Axis).
2. Duba akwatin Juya tsarin dabi'u (Jeri a baya domin) don nuna ginshiƙan a juyi tsari.

Canja matsayi na almara akan ginshiƙi

A cikin ginshiƙi na kek na Excel da ke ƙasa, almara yana a ƙasa. Ina so in matsar da labari zuwa gefen dama na ginshiƙi domin ya fi jawo hankali sosai.

1. Danna-dama akan almara kuma a cikin menu wanda ya bayyana, danna Tsarin almara (Format Legend).
2. A cikin sashe Zaɓuɓɓukan labari (Zaɓuɓɓukan Legend) zaɓi ɗaya daga cikin akwatunan rajista: Daga sama (Na sama), kasa (Kasa), Hagu (Hagu), A dama (Dama) ko top dama (Na sama dama).

Yanzu ina son zane na.

Canza jadawalin takardar don mafi dacewa da ginshiƙi

Idan kawai kuna buƙatar buga ginshiƙi, to kawai canza yanayin takardar a Excel ba tare da jujjuya ginshiƙi da kanta ba. Hoton da ke ƙasa yana nuna cewa ginshiƙi bai dace ba gaba ɗaya akan shafin. Ta hanyar tsoho, takaddun aiki suna bugawa a cikin yanayin yanayin hoto (mafi girma fiye da faɗi). Domin hotona ya yi kama da daidai lokacin da aka buga, zan canza fasalin shafi daga hoto zuwa shimfidar wuri.

1. Zaɓi takardar aiki tare da ginshiƙi don bugawa.
2. danna Tsarin shafi (Layout Page), danna kibiya a ƙarƙashin maɓallin Wayarwa (Gabatarwa) kuma zaɓi wani zaɓi Daji, yanayin fili (Mai shimfidar wuri).

Yanzu a cikin taga samfoti, Ina iya ganin cewa ginshiƙi yayi daidai da yankin da ake bugawa.

Amfani da Kayan Aikin Kyamara don Juya Chart na Excel zuwa Kusurwar Sabani

A cikin Excel, zaku iya juya ginshiƙi zuwa kowane kusurwa ta amfani da kayan aiki kamara. Sakamakon aikin Kyamarori za a iya sakawa kusa da ainihin jadawali ko a sabon takarda.

tip: Idan kana buƙatar jujjuya ginshiƙi da 90°, a wasu lokuta ya isa kawai canza nau'in ginshiƙi. Misali, daga ginshiƙi na mashaya zuwa ginshiƙi.

Don ƙara kayan aiki kamara a kan Toolbar Samun Sauri, yi amfani da ƙaramin down arrow a gefen dama na panel. A cikin menu da ya bayyana, danna Sauran ƙungiyoyi (Ƙarin Umarni).

zabi kamara (Kamara) a cikin jerin Duk ƙungiyoyi (Duk umarni) kuma latsa Add (Ƙara).

Yanzu don amfani da kayan aiki kamara, bi matakan da ke ƙasa.

lura: Da fatan za a tuna cewa ba zai yiwu a yi amfani da kayan aiki ba kamara kai tsaye zuwa ginshiƙi, saboda sakamakon zai iya zama marar tabbas.

1. Ƙirƙiri jadawali ko kowane ginshiƙi.
2. Yana iya zama dole a juya matsayin alamomin gaturun ginshiƙi da 270° ta amfani da menu. Tsarin Axis (Format Axis), wanda aka bayyana a sama. Wannan ya zama dole domin a iya karanta alamun bayan an juya ginshiƙi.
3. Zaɓi kewayon sel waɗanda ginshiƙi ke sama.
4. Danna alamar kamara (Kyamara) akan Toolbar Samun Sauri.
5. Danna kowane tantanin halitta na takardar don ƙirƙirar abun kamara.
6. Yanzu danna ka riƙe rikewar juyawa a saman zanen da aka samu.
7. Juya ginshiƙi zuwa kusurwar da ake so kuma a saki hannun juyawa.

lura: A cikin kayan aiki kamara akwai daya drawback. Abubuwan da ke haifarwa na iya samun ƙaramin ƙuduri fiye da ginshiƙi na asali, kuma suna iya bayyana hatsi ko jaggu.

Charting babbar hanya ce ta nuna bayanai. Zane-zane a cikin Excel suna da sauƙin amfani, bayyananne, gani, kuma za'a iya keɓance ƙirar don dacewa da kowace buƙata. Yanzu kun san yadda ake juya histograms, layi da sigogin kek.

Bayan na rubuta duk waɗannan, Ina jin kamar guru na gaske a fagen jujjuya ginshiƙi. Ina fatan labarina zai taimake ku ku jimre da aikinku. Yi farin ciki kuma inganta ilimin Excel!