Indlela yokusayina i-axis yetshathi kwi-Excel

Anonim

Umzobo namazembe e Microsoft Excel

Emva ukwakha imizobo kwinkqubo Microsoft Excel, engagqibekanga nezamazembe ahlale ungatyikitywanga. Kakade ke, yenza kakhulu kube nzima ukuqonda imixholo mzobo. Kulo mzekelo, umbuzo olubonakalisa igama nezamazembe iba efanelekileyo. ukuchaza indlela atyikitye ezimanyeneyo umzobo kwinkqubo Microsoft Excel, nendlela Let ukuba abele igama kuyo.

Igama axis nkqo

Ngoko ke, sinesizathu umzobo ulungele apho ufuna ukunika amagama nezamazembe.

Itshati e Microsoft Excel

Ukuze unikeze igama axis nkqo lo mzobo, yiya kwi "Ubeko 'lwesithuba soqwalaselo Master of sebenza ngeetshathi kwi Microsoft Excel iribhoni. Nqakraza kwi "Igama axis" iqhosha. Sikhetha, ngomba 'igama iasi eme nkqo omkhulu ". Emva koko, khetha kakuhle apho iya khona igama.

Kukho ezintathu iindlela igama:

  1. ajikelezwe;
  2. nkqo;
  3. Tye.

Sikhetha, masithi isihloko yabuya.

Ukukhetha nokubekwa igama esqwini kwi Microsoft Excel

Lo mbhalo olungagqibekanga livela, ekuthiwa 'igama axis ".

Igama Axis Microsoft Excel

Nje nqakraza kuyo, yaye elinye igama lokuba iisuti oku Axis ngumxholo.

Ukutshintsha igama iasi eme nkqo in Microsoft Excel

Ukuba ukhetha i ukufakwa nkqo igama, uhlobo mbhalo iya kuba yile ilandelayo njengoko thaca ngezantsi.

Igama nkqo ye esqwini kwi Microsoft Excel

Kunye nokubekwa tyaba, ziya isetshenziswe ngolu hlobo lulandelayo la mazwi.

Tye Igama axis kwi Microsoft Excel

Igama iasi enqamlezileyo

Phantse ngendlela efanayo, igama iasi enqamlezileyo wabelwa.

Nqakraza kwiqosha "Igama zamazembe", kodwa eli xesha ndiya ukhethe umba 'igama esqwini omkhulu enqamlezileyo ". Inye kuphela ukhetho yokuhlala - "phantsi esqwini". Ukukhetha.

Ivula igama iasi enqamlezileyo e-Microsoft Excel

Njengoko ngexesha lokugqibela, nqakraza kanye kwi igama, uze utshintshe igama kulowo ukuba siqwalasele kuyimfuneko.

Tshintsha igama alarium axis kwi Microsoft Excel

Ngoko ke, ngamagama abo bobabini, nangeempahla ezibukhali zesinyithi abiwa.

Tshintsha Utyikityo oxwesileyo

Ukongeza igama, i-axis uye utyikityo, oko kukuthi, amagama amaxabiso sisahlula nganye. Uyakwazi ukwenza ezinye utshintsho nabo.

Ukuze ukutshintsha uhlobo nomsayino iasi enqamlezileyo, klikha kwiqhosha "axis", uze ukhethe ixabiso "Main iasi enqamlezileyo" apho. Ngokungagqibekanga, utyikityo ibekwe kwi ekunene nasekhohlo. Kodwa ngokunqakraza kwi izinto "Hayi" okanye "akukho utyikityo", ungayikhubaza ngokubanzi ukubonisa utyikityo tye.

Akukho Utyikityo axis kwi Microsoft Excel

Kwaye emva kokucofa kumba "ekunene ukuya ekhohlo", utyikityo litshintsha lwayo.

I-axis kwi ekunene ukuya ekhohlo kwi Microsoft Excel

Ukongeza, ungacofa kwi "parameter eyongezelelweyo ye-axis ephezulu ye-axis ...".

Tshintshela kwimilinganiselo eyongezelelweyo ye-axis ethe tyaba kwiMicrosoft Excel

Emva koko, iwindow ivulwa apho kunikezelwa khona inani le-Axis I-Axitions: Isithuba esiphakathi kwezahlulo, ifomathi yedatha, ifomathi yedatha, ifowuni, uhlobo lomgca, nangaphezulu.

Iiparamitha ezongezelelweyo ze-Axis kwiMicrosoft Excel

Ukutshintsha utyikityo oluthe nkqo

Ukutshintsha isiginali ethe nkqo, cofa kwi "Axis", emva koko uye kwigama "i-axis enkulu ethe nkqo. Njengoko ubona, kule meko, kubonakala ngathi khetha ngaphezu kokukhetha ukubekwa kwezinto ezisayiniweyo kwi-Axis. Awunakubonisa i-axis konke konke, kodwa unokukhetha enye yezinketho zodidi ezine:

  • ngamawaka;
  • kwizigidi;
  • Kwizigidi ngezigidi;
  • ngohlobo lwe-logarithmic.

Ukulawulwa kwe-axis ethe nkqo kwiMicrosoft Excel

Njengoko sibonisa ishedyuli engezantsi, emva kokukhetha into ethile, amaxabiso esikali atshintshwa ngokufanelekileyo.

I-Axis ethe nkqo kumawaka eeMicrosoft Excel

Ukongeza, unokukhetha ngokukhawuleza "iiparamitha ezongezelelweyo ze-axis ephambili ...". Ziyafana nento efanelekileyo ye-axis ethe tyaba.

Inguqu kwimilinganiselo eyongezelelweyo ye-Axis ethe nkqo kwiMicrosoft Excel

Njengoko ubona, ukuqukwa kwegama kunye nokutyikitywa kwe-axes kwinkqubo ye-Microsoft ye-Excel ayisiyonto inzima kakhulu, kwaye, ngokubanzi, ithile. Kodwa, emva kwayo yonke loo nto, kulula ukuyifumana kuye, nokuba nesikhokelo esineenkcukacha kwisenzo. Yiyo loo nto, kunokwenzeka ukuba songe ixesha lokufunda ezi mpawu.

Funda ngokugqithisileyo