Funda Indlela Yokubonisa okanye Ukufihla Iikripthi zeTyati kwi-Excel

I-axis kwitshathi okanye igrafu kwi-Excel okanye i-Google Spreadsheets ngumgca ongqambileyo okanye wecala ophethe iiyunithi zomlinganiselo. Imijelo emngceleni yendawo yendawo yamatye ekholomu (iibrafu zebha), iigrafu zegrafti kunye namanye amashadi. I-axis isetyenziswe ukubonisa iiyunithi zomlinganiselo kwaye unike isakhelo sokubhengezwa kwidatha eboniswe kwitshathi . Uninzi lwamashadi, afana nekholomu kunye namachashaza omgca, zinemikhono emibili esetyenziselwa ukulinganisa nokuhlukanisa idatha:

Iimpawu zeehadi ze-3-D

Ukongeza kwimijelo engqambileyo neyiyo, ama-3-D amashadi ane-axis yesithathu - i-axis-ebizwa ngokuba yi- axis esecaleni okanye i- axis ecacileyo evumela idatha ukuba ihlelwe kwinqanaba lesithathu (ubunzulu) beseshati.

I-Axis ene-Horizontal

I-axis e-horizontal, esebenza ngaphantsi kwendawo yesalathiso, ngokuqhelekileyo iqulethe izihloko ezifakwe kwi-data kwiphepha lokusebenzela .

Axis eViweyo

I-axis ye-vertical isebenza ngasecaleni lesalathisi kwindawo leyo. Isikali salesi sixhasi sivame ukuveliswa yinkqubo esekelwe kwiimpawu zedatha ezicwangcisiweyo kwitshati.

I-Axis eSekondari eSekondari

I-axis yesibini ehambayo-isebenza kwicala elifanelekileyo letshathi-lingasetyenziswa xa ibonisa iintlobo ezimbini okanye ezahlukeneyo zedatha kwitshati enye. Isetyenziswe kwakhona ukutshintsha amanani eenkcukacha.

Igrafu yemozulu okanye i- climatograph ngumzekelo wetshathi edibeneyo eyenza ukusetyenziswa kwe-axis ebonakalayo yesibini ukubonisa iqondo lokushisa kunye nexesha lokunkcenkceshela kunye nexesha kwichati enye.

Iimpawu zeAxes

Zonke iitshati zeeshadi kufuneka zichongwe ngesihloko se-axis esibandakanya iiyunithi eziboniswe kwi-axis.

Amashadi ngaphandle kweengcingo

I-Bubble, i-radar, ne-pie charts ziintlobo zetshathi ezingasebenzisi izikhwama ukubonisa idatha.

Fihla / Ubonise Iikripati zeehadi

Kwiintlobo ezininzi zeentshathi, i-axis ye-vertical (i-aka yexabiso okanye i- Y axis ) kunye ne-axis ene-axis (i-aka category okanye i- X axis ) iboniswa ngokuzenzekelayo xa isatshati sidalwa kwi-Excel.

Akukho mfuneko, nangona kunjalo, ukubonisa yonke okanye nayiphina imirhubhe yetshathi. Ukufihla enye okanye ngaphezulu kweexes kwiinguqu zakutsha ze-Excel:

  1. Nqakraza naphi na kwitshathi ukuze ubonise iqhosha leTyrt Elements -uphawu olongezelelweyo ( + ) kwicala lasekunene letshathi njengoko kuboniswe kumfanekiso ongentla,
  2. Ukucofa iqhosha leTyrt Elements ukuvula imenyu yezinketho;
  3. Ukufihla zonke iisethi, susa uphawu lokukhangela kwi-Axes yokukhetha phezulu kwimenyu;
  4. Ukufihla enye okanye amanqwanqwa amaninzi, gxuma umgca we mouse kwimpendulo ekude ephezulu ye- Axes yokukhetha ukubonisa utolo oluchanekileyo;
  5. Cofa kwitolo ukuba ubonise uluhlu lweexeshi ezingabonakaliswa okanye ezifihliweyo kwetshathi yangoku;
  6. Susa i-checkmark kwiimpawu ezifihliweyo;
  7. Ukuze ubonise enye okanye amanqwanqwa angaphezulu, faka i-markmarks eduze kwamagama abo kuhlu.