Hello moni, Tecnobits ndi owerenga chidwi! Mwakonzeka kuphunzira momwe mungawonjezere axis yachiwiri mu Google Mapepala ndikupatsa mphamvu zambiri pamatchati anu? Tiyeni tilowe mu dziko la maspredishiti kuti tipindule nawo! Pitirizani!
Kodi gawo lachiwiri mu Google Mapepala ndi chiyani?
- Mzere wachiwiri mu Google Mapepala ndi njira yachiwiri yoyimirira kapena yopingasa yomwe imawonjezedwa ku tchati kuti iwonetse deta yowonjezera. Izi ndizothandiza mukakhala ndi ma data okhala ndi masikelo osiyanasiyana kapena mayunitsi oyezera.
- Kuwonjezera kwa a sekondale shaft amalola kuwona bwino mgwirizano pakati pa magulu awiri a data omwe akanakhala ovuta kutanthauzira pa axis imodzi.
Kodi ndingawonjezere bwanji axis yachiwiri pa tchati cha Mapepala a Google?
- Choyamba, tsegulani spreadsheet mu Google Sheets ndikusankha selo kapena magulu angapo omwe mukufuna kuyikamo mu tchati.
- Kenako, dinani "Ikani" mu kapamwamba menyu ndi kusankha "Tchati".
- Pazenera la Tchati, sankhani mtundu wa tchati womwe mukufuna kupanga, monga "Tchati cha Mzere" kapena "Chati cha Bar."
- Tchaticho chikayikidwa mu spreadsheet, dinani kuti muwunikire.
- Kenako, dinani chizindikiro cha "Sinthani" chomwe chili kukona yakumanja kwa tchati.
- Kuchokera pa menyu yotsikira pansi, sankhani »Sinthani Mwamakonda Anu" kenako "Series".
- Tsopano, pazosankha zomwe mukufuna kuwonetsa pa axis yachiwiri, dinani "Axis" menyu yotsikira ndikusankha "Yachiwiri."
- Pomaliza, dinani "Ndachita" kuti mugwiritse ntchito zosinthazo ndipo muwona kuti yawonjezedwa. sekondale shaft ku graph.
Kodi ndingawonjezere mutu ku axis yachiwiri mu Google Mapepala?
- Inde, ndizotheka kuwonjezera mutu ku sekondale shaft mu Mapepala a Google kuti mumveke bwino komanso momveka bwino.
- Kuti muchite izi, dinani tchati kuti musankhe ndikudina chizindikiro "Sinthani" chomwe chili pamwamba kumanja.
- Kuchokera pa menyu yotsitsa, sankhani "Mwambo" kenako "Secondary Axis."
- Mutha kuyika mutu womwe mukufuna axis sekondale mu bokosi logwirizana.
- Mukangolowa mutuwo, dinani "Ndachita" kuti mugwiritse ntchito zosinthazo ndipo muwona kuti sekondale shaft tsopano ili ndi mutu wofotokozera.
Kodi pali njira yosinthira makonda a axis achiwiri mu Google Mapepala?
- Inde, ndizotheka kusintha mawonekedwe a sekondale shaft mu Google Mapepala kuti musinthe malinga ndi zomwe mumakonda.
- Kuti muchite izi, dinani tchati kuti musankhe ndiyeno dinani chizindikiro cha "Sinthani" pakona yakumanja yakumanja.
- Kuchokera pa menyu yotsitsa, sankhani "Custom" ndiyeno "Mzere wa Line" kusintha mawonekedwe a sekondale shaft.
- Mukhozanso kusintha mtundu, makulidwe, ndi mtundu wa mzere wa sekondale shaft malinga ndi zomwe mumakonda.
- Mukapanga zosintha zomwe mukufuna, dinani "Wachita" kuti mugwiritse ntchito makonda anu sekondale shaft.
Kodi ndingachotse nsonga yachiwiri pa tchati mu Mapepala a Google?
- Inde, ndizotheka kuchotsa a sekondale shaft cha tchati mu Mapepala a Google ngati simuchifunanso kapena ngati munalakwitsa kuwonjezera.
- Kuti muchite izi, dinani tchati kuti musankhe ndiyeno dinani chizindikiro cha Sinthani pakona yakumanja yakumanja.
- Kuchokera pa menyu otsika, sankhani "Mwambo" ndiyeno "Series."
- Kwa seti ya data yomwe ili ndi sekondale shaft, dinani "Axis" menyu yotsikira ndi kusankha "Choyamba" m'malo mwa "Yachiwiri."
- Pomaliza, dinani "Chachitika" kuti mugwiritse ntchito zosinthazo ndipo mudzawona kuti sekondale shaft zachotsedwa pa tchati.
Kodi ndingawonjezere ma axis achiwiri ku tchati cha Google Mapepala?
- Sizingatheke kuwonjezera mwachindunji kuposa chimodzi sekondale shaft mu tchati chimodzi mu Google Mapepala.
- Komabe, mutha kuchitanso chimodzimodzi popanga ma chart angapo okhala ndi nkhwangwa zina zachiwiri ndikuzikuta pa spreadsheet.
- Mwanjira iyi, mutha kufananiza ma data angapo ndi masikelo osiyanasiyana kapena mayunitsi ogwiritsa ntchito ma axles achiwiri mu ma graph osiyana.
Kodi zina ndi ziti zomwe mungagwiritse ntchito powonjezera axis yachiwiri mu Google Mapepala?
- Kugwiritsa ntchito powonjezera a sekondale shaft Mu Google Mapepala ndizoyimira deta yachuma, kumene ndizofala kufananiza zosintha monga ndalama ndi ndalama zomwe zimagwiritsidwa ntchito pa graph yomweyo.
- Zimakhalanso zothandiza poyerekeza deta yogwira ntchito, monga malonda ndi chiwerengero cha makasitomala, omwe angakhale ndi mayunitsi osiyanasiyana oyezera.
- Kugwiritsa ntchito ma axles achiwiri Zimapangitsa kuti zikhale zosavuta kuwona ndikumvetsetsa maubwenzi pakati pa ma seti a data omwe mwina zingakhale zovuta kutanthauzira pa axis imodzi.
Kodi ndingaphunzire bwanji zambiri zowonera data mu Google Sheets?
- Kuti mudziwe zambiri zowonera deta mu Google Sheets, mutha kuwona maphunziro apa intaneti omwe amapereka malangizo apamwamba komanso njira zopangira ma chart abwino.
- Mutha kuyang'ananso zolemba zovomerezeka za Google Sheets, zomwe zimapereka mwatsatanetsatane za ntchito zonse ndi mawonekedwe okhudzana ndi kujambula.
- Kuphatikiza apo, kutenga nawo gawo pamabwalo apaintaneti ndi madera odzipereka ku data kuwoneratu kukupatsani mwayi wogawana zomwe mwakumana nazo komanso kuphunzira kuchokera kwa ogwiritsa ntchito ena.
Kodi pali mapulagini a chipani chachitatu kapena zida zomwe zimawongolera mawonekedwe a data mu Google Mapepala?
- Inde, pali zowonjezera zingapo zomwe zilipo pa Google Sheets zomwe zimapereka zowonjezera ndi zida zowonera deta.
- Ena mwa mapulaginiwa amakulolani kuti mupange ma chart ovuta komanso okonda makonda anu, onjezani ma chart atsopano, kapena kupeza ntchito zowunikira zapamwamba.
- Onani Google Sheets Add-on Store kuti mupeze zosankha zomwe zikugwirizana ndi zosowa zanu zowonera deta.
Tiwonana nthawi yina, Tecnobits! Musaiwale kuwonjezera axis yachiwiri mu Google Mapepala kuti mupatse ma chart anu mphamvu zambiri. Tiwonana posachedwa!
Ndine Sebastián Vidal, mainjiniya apakompyuta omwe amakonda ukadaulo komanso DIY. Komanso, ine ndine mlengi wa tecnobits.com, komwe ndimagawana nawo maphunziro kuti ukadaulo ukhale wofikirika komanso womveka kwa aliyense.