Funda indlela yokubonisa noma ukufihla amashadi we-Ishadi ku-Excel

I-axis eshadini noma igrafu ku-Excel noma i-Google Spreadsheets iyi-line enezingqimba noma eziqondile eziqukethe amayunithi wokulinganisa. Izinkomba ziphezu kwendawo yendawo yamashadi ekholomu (ibrafu yamabha), amagrafu emigqa, namanye amashadi. I-axis isetshenziselwa ukubonisa amayunithi wesilinganiso futhi inikeze uhlaka lokubhekisela kwedatha eboniswe eshadini . Amashadi amaningi, njengekholomu namashadi womugqa, anama-axes amabili asetshenziselwa ukulinganisa nokuhlukanisa idatha:

Ama-Axes we-Chart 3-D

Ngaphandle kwezingxenyana ezizungezile neziqondile, amashadi a-3-D ane-axis yesithathu - i-axis ye-z - ebizwa nangokuthi i- axis yesibili eqondile noma i- axis ejulile evumela ukuthi idatha ihlelwe eceleni kwesithathu (ukujula) kweshadi.

I-Axis ephelele

I-axis e-horizontal, egijima ngaphansi kwesendaweni yendawo, ngokuvamile iqukethe izihloko zesigaba ezithathwe kusuka kudatha kushidi lokusebenzela .

I-Axis eqondile

I-axis yomsindo igijima ngakwesokunxele kwendawo yendawo. Isikali salesi sigaba sivame ukukhiqizwa nguhlelo olusekelwe ezindinganisweni zedatha ezihlelwe eshadini.

I-Axis e-Vertical Secondary

I-axis yesibili ebonakalayo-egijima ngakwesokudla kweshadi-ingasetshenziswa lapho ibonisa izinhlobo ezimbili noma eziningi ezahlukene kwedatha eshadini elilodwa. Ibuye isetshenziselwe ukuhlela amanani wedatha.

Igrafu yesimo sezulu noma i- climatograph yisibonelo seshadi elihlanganisiwe elisebenzisa i-axis yesibili ebonakalayo ukubonisa idatha yokushisa neyemvula kanye nesikhathi eshadini elilodwa.

Iziqephu zezinhloko

Zonke izinkomba zeshadi kufanele zikhonjwe ngesihloko se-axis esihlanganisa amayunithi aboniswe ku-axis.

Amashadi ngaphandle kwama-Axes

Amashadi we-Bubble, radar, nama-pie yizinhlobo zezinhlobo zamashadi ezingasebenzisi izinkomba zokubonisa idatha.

Fihla / Ubonise Amashadi Wekhadi

Kuzo izinhlobo eziningi zeshadi, i-axis eqondile (i-aka value noma i- axis Y ) kanye ne-axis enezingqimba ( isigaba se- aka noma i- X axis ) iboniswa ngokuzenzekelayo uma ishadi lidalwa ku-Excel.

Nokho, akudingekile ukuthi ubonise konke noma yiziphi izinkomba zeshadi. Ukufihla okukodwa noma ngaphezulu kwezinguquko ezinguqulweni zakamuva ze-Excel:

  1. Chofoza noma yikuphi eshadini ukuze ubonise inkinobho ye- Chart Elements -uphawu oluthe xaxa ( + ) ngakwesokudla kweshadi njengoba kuboniswe esithombeni ngenhla,
  2. Ukuchofoza inkinobho ye- Chart Elements ukuvula imenyu yezinketho;
  3. Ukufihla zonke izinkomba, susa uphawu lokuhlola kusuka ku-Axes inketho ngaphezulu kwemenyu;
  4. Ukuze ufihle eyodwa noma ngaphezulu izinkomba, gxilisa isisombululo segundane ekugcineni kwesokudla kakhulu kwe- Axes yokukhetha ukubonisa umcibisholo oqondile;
  5. Chofoza kumcibisholo ukuze ubonise uhlu lwezinkomba ezingaboniswa noma ezifihliwe eshadini samanje;
  6. Susa uphawu lokuhlola kusuka ezihlahleni ezizofihlwa;
  7. Ukuze ubonise eyodwa noma ngaphezulu izinkomba, engeza amashekthi eduze kwamagama abo kuhlu.