Dzidza Nzira Yokuratidza Kana Kuvanza Chati Axes mu Excel

Nheyo pane chati kana girafu muExcel kana Google Spreadsheets iri mutsara wakarurama kana wechiratidzo ane zvigadziro zvezviyero. Masango acho ari kumucheto nzvimbo yekorodhe yemarata (bar grafu), mifananidzo yemirasi, nemamwe matha. An axis inoshandiswa kuratidza zviyero zvechiyero uye inopa chimiro chekutsvaga kwezvinhu zvakaratidzwa mu chati . Mifananidzo yakawanda, yakadai sechindori nematarenda emutsara, ine majeko maviri anoshandiswa kuyera uye kugovera deta:

Dhirt 3-D Majeko

Kuwedzera kune zvisinganzwisisiki uye zvakananga, ma-charts a 3-D ane aisisiti yechitatu - z axis - inonziwo chechipiri yechidimbu chekutsvaga kana kuti yakadzika midzi inobvumira deta kuti iongororwe pamwe nechetatu (yakadzika) yechati.

Horizontal Axis

Iyo yakanyatsoyerera x axis, inomhanya pamwe nechepasi penzvimbo yenzvimbo, kazhinji inosanganisira zvinyorwa zvitsva zvakatorwa kubva pane dhesi iri mueseji yebasa .

Vertical Axis

Irosi y y axis inomira kurutivi rworuboshwe rwemaiti. Chiyero chechikwereti ichi chinowanzogadzirwa nepurogiramu yakatarwa nehuwandu hwemashoko huri kurongwa mu chati.

Secondary Secondary Vertical Axis

Chipiri chechidimbu-chinomira-rutivi rworudyi rwechati-chinogona kushandiswa pakuratidza zviviri kana kupfuura zvakasiyana-siyana zve data mune imwe chati. Inoshandiswawo kuronga huwandu hwemashoko.

Mamiriro emamiriro okunze kana kuti climatograph muenzaniso wekubatanidza chati inoshandisa sendima yechipiri yakananga kuratidza zvose zviri kutonhora uye dhizivo data vs. nguva mu chati imwe chete.

Axes Titles

Zvose zvinoshandisa mahedheni zvinofanira kuzivikanwa nechitsiko chekutsvaga chinosanganisira mairi akaratidzwa mu-axis.

Matikiti asina Mashizha

Bubble, radar, uye pie charts ndevamwe mapepa emhando dzisingashandisi mazai kuratidzira deta.

Viga / Ratidza Chati Axes

Pamusoro pematarenda akawanda, vertical axis (aka value kana Y axis ) uye horizontal axis (aka category kana X axis ) inoratidzwa pakarepo kana chati yakasikwa muExcel.

Hazvina kudiwa, zvakadaro, kuratidza zvose kana chimwe chezvikwereti zve chati. Kuvanza imwechete kana kuti mamwe majeko mune zvinyorwa zvekare zveExcel:

  1. Dhodza chero kupi zvako pane chati kuti uratidze bhatani reTean Elements -kuwedzera chiratidzo ( + ) kurudyi rwe chati pane kuratidzwa mumufananidzo uri pamusoro,
  2. Kushandura bhatani reTear Elements kuti uzarure menyu yezvasarudzo;
  3. Kuti uvanze matambo ose, bvisa check check kubva kuAxes kusarudza pamusoro pemenyu;
  4. Kuti uvanze imwechete kana kuti mamwe mabheji, svetedza mutsara weguru kumucheto uri kurudyi weAxes chisarudzo kuti uone museve wekona;
  5. Dzvanya pamuseve kuti uratidze runyora rwemasikisi anokwanisa kuiswa kana kuvanzwa kwechati chazvino;
  6. Bvisa chekucherechedza kubva kumatare okuvanzwa;
  7. Kuti uratidze imwe kana mimwe mihizha, wedzera checkmarks pedyo nemazita avo mune urongwa.