Kana iwe uchida kuita chati mune Excel uye / kana Google Sheetsiti, zvakakosha kunzwisisa zvinorehwa nenhepfenyuro dzepa data, data markers, uye dheedhi re data.
Kunzwisisa Kushandiswa kweData Series uye Zvimwe Zviratidzo Zvimwe muExpcel
Nhamba yepashoko inokosha imwe inowanikwa mune imwe sero rebasa rinorongwa mune chati kana girafu .
Dhi marker is column, dot, pie slice, kana imwe chiratidzo mune chati iyo inomiririra iyo kukosha mu chati. Semuenzaniso, mumutsara wegrafu, nheyo imwe neimwe pamutsara ibasa rekuisa deta rinomiririra imwe nhamba ye data inowanikwa mumusero webasa .
A datata label inopa ruzivo nezvemunhu mumwe chete wezvinyorwa, zvakadai senhamba iri kuva graphed kana sehamba kana seperesenti.
Kazhinji inoshandiswa yedheta mabhuku inosanganisira:
- Nhamba dzepambare - dzakatorwa kubva kune dzimwe pfungwa dzepaduku mubasa rekushanda ;
- Nhepfenyuro mazita - tsanangura mapuranga kana mitsetse yematarenda mune chepaji. Iyo inowanzoshandiswa pakurati yemasharuti, mabhadhi emabhadhi, uye mifananidzo yematafura;
- Nhamba mazita - anotsanangura mumwe munhu nhamba yepasiti mune imwe tsanangudzo yedata. Iyo inowanzoshandiswa pamapati epie;
- Mazana emakero - akaverengwa kuburikidza nekuparadzanisa minda imwe neimwe mumutsara nehuwandu hwehuwandu hwemutsara. Iyo inowanzoshandiswa pamapati epie;
Nhepfenyuro yedhesi iboka rehutano hunoenderana nenyaya kana zviratidzo zvinorongwa mumarati uye mairafu. Mienzaniso yehurukuro ye data ndeyi:
- Mitsara yega yega mumurongo wetsamba
- Mamwe mapurumendi mune imwe chinyorwa chati
Apo dzakawandisa dhepfenyuro dzedzinza dzakarongerwa mune rimwe chati, tsanangudzo imwe neimwe yezvinyorwa inoratidzwa nehuwandu hwemavara kana shading pattern.
Munyaya yekorosi kana bharati, kana mazamu akawanda kana mabhagi akafanana nemuvara, kana kuti ane mufananidzo wakafanana mune pepigragraph , zvinosanganisira imwe nyaya dzakasiyana.
Mapepa emakumbo anowanzochengetwa kune imwe chete nyaya dzinoenderana nechadhi. Izvo zvidimbu zveiyo pie ndiyo dhiyabhorosi yezvinyorwa panzvimbo pane deta ye data.
Kugadziriswa Kwevamwe Mavara Mavara
Kana munhu wepodha imwe nhepfenyuro achikosha mune imwe nzira, kufungidzirwa kwe data marker iyo inomiririra pfungwa iyo muchati inogona kuchinjwa kuita kuti marker irege kubva kune dzimwe pfungwa dziri mumatsetse.
Semuenzaniso, ruvara rwekanda imwechete munhare yechandara kana imwe pfungwa munharaunda yemutsara inogona kuchinjwa pasina kukanganisa mamwe maonero ari munhepfenyuro nekutevera matanho ari pasi apa.
Kuchinja Muvara weKamwe Column
- Dzvanya kamwe pane imwe nyaya dzakasiyana-siyana mumutsetse chati. Zvose zvinyorwa zvemuvara mumwechete mu chati zvinofanira kusimbiswa. Kirasi imwe neimwe yakakomberedzwa nemuganhu unosanganisira madonhwe maduku pamakona.
- Dzvanya kechipiri pane chinyorwa mu chati kuti ichishandurwe-chete iyo column inofanira kuiswa pachena.
- Dzvanya ku Format yebhubhoni, imwe yezvakakoshe tabha akawedzerwa kubhoni kana chati yakasarudzwa.
- Dzvanya paChimiro Chizadza chinyorwa kuti uzarure mifananidzo yeTill Colors.
- Muchikamu cheClass Colors pane menyu sarudza Blue.
Izvozvi zvinyorwa zvematanho zvinogona kushandiswa kushandura pfungwa imwe chete mumurongo wetsamba. Ingosarudza mumwe munhu dot (marker) pamutsara munzvimbo yekomba imwe chete.
Exploding Pie
Sezvo zvisikwa zvipi zvebhokisi repadhe kazhinji mavara akasiyana-siyana kutanga, kusimbisa chiduku chimwechete kana deta inotoda inoda nzira yakasiyana kubva kune iyo inoshandiswa pamakorani nematsetse emutsara.
Kusimbiswa kunowanzowedzerwa kupeta mapepa kuburikidza nekuputika imwechete ye pie kubva kune imwe shata.
Wedzera kusimbiswa neChirati cheCombo
Imwe nzira yekusimbisa marudzi akasiyana ehudziro mubati ndeyokuratidzira mairi maviri kana kupfuura emhando dzechati mu chati imwe, yakadai sechandori chati uye mutsara wegamba.
Nzira iyi inowanzotorwa apo maitiro ari graphed akasiyana zvakasiyana, kana apo marudzi akasiyana e data ari graphed. Chimwe chiitiko chinowanzoitwa climatograph kana girafu yemamiriro ekunze, iyo inosanganisira dutu uye yechando ye data yeimwe nzvimbo pane chati imwe.
Mutsara kana makirati akabatwa anoshandiswa nekugadzirisa imwe kana kupfuura dhepfenyuro yedhesi pane yechipiri chepamusoro kana Y axis.