Sannu hello, Tecnobits da masu karatu masu ban sha'awa! Shirya don koyon yadda ake ƙara axis na biyu a cikin Google Sheets kuma ku ba da ƙarin ƙarfi ga sigogin ku? Bari mu nutse cikin duniya na maƙunsar rubutu kuma mu sami mafi kyawun su! Ku tafi!
Menene axis na biyu a cikin Google Sheets?
- Sakandare axis a cikin Google Sheets shine axis na biyu a tsaye ko a kwance wanda aka ƙara zuwa ginshiƙi don nuna ƙarin bayanai. Wannan yana da amfani idan kuna da saitin bayanai tare da ma'auni daban-daban ko raka'a na aunawa.
- Ƙarin a secondary shaft yana ba da damar ganin a sarari alakar da ke tsakanin saitin bayanai guda biyu waɗanda in ba haka ba zai yi wahala a fassara su akan axis guda ɗaya.
Ta yaya zan iya ƙara axis na biyu a cikin ginshiƙi na Google Sheets?
- Da farko, buɗe maƙunsar bayanai a cikin Google Sheets kuma zaɓi tantanin halitta ko kewayon sel da kuke son haɗawa a cikin ginshiƙi.
- Na gaba, danna "Saka" a cikin mashaya menu kuma zaɓi "Chart".
- A cikin taga Chart, zaɓi nau'in ginshiƙi da kuke son ƙirƙira, kamar "Line Chart" ko "Bar Chart."
- Da zarar an saka ginshiƙi a cikin maƙunsar bayanai, danna shi don haskaka shi.
- Sa'an nan, danna kan gunkin "Edit" da ke bayyana a kusurwar dama ta sama na ginshiƙi.
- Daga menu mai saukarwa, zaɓi »Personalize» sannan kuma «Series».
- Yanzu, don saitin bayanan da kuke son nunawa akan kusurwoyi na biyu, danna menu mai saukarwa na "Axis" kuma zaɓi "Secondary."
- A ƙarshe, danna "An yi" don amfani da canje-canje kuma za ku ga cewa an ƙara . secondary shaft zuwa jadawali.
Zan iya ƙara take zuwa axis na biyu a cikin Google Sheets?
- Ee, yana yiwuwa a ƙara take zuwa ga secondary shaft a cikin Google Sheets don bayyana shi kuma mafi fahimta.
- Don yin wannan, danna kan ginshiƙi don zaɓar shi sannan danna alamar "Edit" a saman kusurwar dama.
- Daga menu mai saukewa, zaɓi "Custom" sannan kuma "Axis na biyu."
- Kuna iya shigar da take da kuke so don secondary axis a cikin akwatin rubutu masu dacewa.
- Da zarar kun shigar da take, danna "An gama" don amfani da canje-canjen kuma zaku ga cewa secondary shaft yanzu yana da take mai siffantawa.
Shin akwai wata hanya don tsara tsarin axis na biyu a cikin Google Sheets?
- Ee, yana yiwuwa a tsara tsarin tsarin secondary shaft a cikin Google Sheets don daidaitawa da abubuwan da kuke so na gani.
- Don yin wannan, danna kan ginshiƙi don zaɓar shi sannan danna alamar "Edit" a saman kusurwar dama.
- Daga menu mai saukewa, zaɓi "Custom" sannan kuma "Salon Layi" don daidaita yanayin bayyanar. secondary shaft.
- Hakanan zaka iya canza launi, kauri, da nau'in layi na secondary shaft gwargwadon abubuwan da ka zaba.
- Da zarar kun yi canje-canjen da ake so, danna "An yi" don amfani da keɓancewa ga secondary shaft.
Zan iya cire axis na biyu daga ginshiƙi a cikin Google Sheets?
- Ee, yana yiwuwa a share a secondary shaft na wani chart a cikin Google Sheets idan ba ku buƙatar shi ko kuma idan kun yi kuskuren ƙara shi.
- Don yin wannan, danna kan ginshiƙi don zaɓar shi sannan danna gunkin Gyara a kusurwar dama ta sama.
- Daga menu mai saukewa, zaɓi "Custom" sannan kuma "Series."
- Don saitin bayanan da ke da secondary shaft, danna menu na ƙasa na "Axis" kuma zaɓi "Primary" maimakon "Secondary."
- A ƙarshe, danna "An yi" don amfani da canje-canje kuma za ku ga cewa secondary shaft an cire shi daga ginshiƙi.
Zan iya ƙara axis fiye da ɗaya zuwa ginshiƙi na Google Sheets?
- Ba zai yiwu a ƙara fiye da ɗaya kai tsaye ba secondary shaft a cikin ginshiƙi ɗaya a cikin Google Sheets.
- Koyaya, zaku iya cimma irin wannan tasiri ta ƙirƙirar ginshiƙi fiye da ɗaya tare da gatura na sakandare daban-daban da lulluɓe su akan maƙunsar rubutu.
- Ta wannan hanyar, zaku iya kwatanta saitin bayanai da yawa tare da ma'auni ko raka'a daban-daban ta amfani da su sakandare axles a daban-daban jadawali.
Menene wasu aikace-aikace masu amfani na ƙara axis na sakandare a cikin Google Sheets?
- A aikace aikace na ƙara a secondary shaft A cikin Google Sheets yana cikin wakilcin bayanan kuɗi, inda ya zama ruwan dare don kwatanta masu canji kamar kudin shiga da kashe kuɗi a cikin jadawali ɗaya.
- Hakanan yana da amfani yayin kwatanta bayanan aiki, kamar tallace-tallace da adadin abokan ciniki, waɗanda ƙila su sami nau'ikan ma'auni daban-daban.
- Amfani da sakandare axles Yana ba da sauƙi don hangowa da fahimtar alaƙa tsakanin saitin bayanai waɗanda in ba haka ba zai zama da wahala a fassara su akan gadi ɗaya.
Ta yaya zan iya ƙarin koyo game da duba bayanai a cikin Google Sheets?
- Don ƙarin koyo game da hangen nesa bayanai a cikin Google Sheets, zaku iya bincika koyawa kan layi waɗanda ke ba da tukwici da dabaru don ƙirƙirar sigogi masu inganci.
- Hakanan zaka iya bincika takaddun takaddun Google Sheets na hukuma, wanda ke ba da cikakkun bayanai game da duk ayyuka da fasalulluka masu alaƙa da tsarawa.
- Bugu da ƙari, shiga cikin tarukan kan layi da al'ummomin da aka sadaukar da su ga bayanai gani zai ba ku damar raba gogewa da koyo daga sauran masu amfani.
Shin akwai wasu plugins ko kayan aiki na ɓangare na uku waɗanda ke haɓaka hangen nesa na bayanai a cikin Google Sheets?
- Ee, akwai ƙarin ƙari da yawa don Google Sheets waɗanda ke ba da ƙarin fasali da kayan aikin gani bayanai.
- Wasu daga cikin waɗannan plugins suna ba ku damar ƙirƙirar ƙarin hadaddun da keɓaɓɓen sigogi, ƙara sabbin nau'ikan ginshiƙi, ko samun damar ayyukan bincike na ci gaba.
- Bincika Shagon Ƙarar Sheets na Google don nemo zaɓuɓɓukan da suka dace da takamaiman buƙatun gani na bayananku.
Sai anjima, Tecnobits! Kar a manta da ƙara axis na biyu a cikin Google Sheets don ba da ƙarin ƙarfin sigogin ku. Sai anjima!
Ni Sebastián Vidal, injiniyan kwamfuta mai sha'awar fasaha da DIY. Bugu da ƙari, ni ne mahaliccin tecnobits.com, inda nake raba koyaswar don sa fasaha ta fi dacewa da fahimtar kowa ga kowa.