Igishushanyo cy'umurongo muri Excel

Ihame ryo gukora imbonerahamwe

Igishushanyo cy'umurongo muri Excel gikoreshwa mu kwerekana amakuru atandukanye atandukanye ajyanye n'ameza watoranijwe. Kubera iyo mpamvu, ibikenewe ntibivuka gusa kubirema gusa, ahubwo bikaba bigena mubihe byabo. Ubwa mbere, bigomba gutondekwa guhitamo imbonerahamwe yumurongo, hanyuma ukomeze guhindura ibipimo byayo.

1. Shyira ahagaragara igice cyifuzwa cyangwa rwose, ufashe buto yimbeba yibumoso.



2. Kanda ahanditse.



3. Muri Blot hamwe nimbonerahamwe, kwagura "histogramu" kumanuka, aho hari ibishushanyo bitatu bisanzwe bishushanyije kandi hari buto yo kujya muri menu hamwe nibindi biryo.



4. Niba ukanze ibya nyuma, "shyiramo imbonerahamwe" Idirishya rizafungura, aho, kuva kurutonde rwamoko, hitamo "umurongo".



5. Reba imbonerahamwe zose zubu kugirango uhitemo imwe ibereye kwerekana amakuru y'akazi. Verisiyo iri kumwe nitsinda riratsinda mugihe ukeneye kugereranya indangagaciro mubyiciro bitandukanye.



6. Ubwoko bwa kabiri numurongo ukwegeranya, bigufasha kwerekana amakuru ya buri kintu kuri kimwe.



7. Ubwoko bumwe bwimbonerahamwe, ariko gusa hamwe na "bisanzwe" prefix bitandukanye namakuru yabanjirije ayambere. Hano barerekanwa mubipimo byijanisha, kandi ntibigereranyije.



8. Ubwoko butatu bukurikira bwa kar igishushanyo ni bibiri-bingana. Iya mbere irema neza itsinda rimwe ryaganiriweho hejuru.



9. Igishushanyo mbonera kizengurutse kituma bishoboka kureba igice kingana muri rusange.



10. Umubumbe usanzwe ni kimwe nibipimo bibiri, byerekana amakuru ajyanye na ijana.



11. Hitamo kimwe mubyiza byateganijwe, reba kubireba hanyuma ukande kuri ENTER kugirango wongere kumeza. Fata igishushanyo hamwe na buto yimbeba yibumoso kugirango ubimure umwanya woroshye.

Guhindura ishusho yumurongo wimbonerahamwe itatu

Ibishushanyo bitatu-bine nabyo biramenyekana kandi kubera ko bisa neza kandi bikakwemerera muburyo umwuga ugereranya amakuru mugihe utanga umushinga. Imikorere isanzwe ya Excel irashobora guhindura ubwoko bwuruhererekane hamwe namakuru, kuva muburyo bwa kera. Noneho urashobora guhindura imiterere yishusho, ubiha igishushanyo mbonera.

1. Urashobora guhindura ishusho yumurongo mugihe washyizweho muburyo butatu, niko bimeze ubu niba gahunda itarayongereye kumeza.



2. Kanda LKM kumurongo wibishushanyo hanyuma umare kugirango ugaragaze indangagaciro zose.



3. Kora buto ikwiye hamwe na buto yimbeba iburyo no muri menu ya menu, jya mubice "Amakuru ya Data".



4. Kuburenganzira buzafungura idirishya rito rishinzwe gushyiraho ibipimo byumurongo ukomoka. Muri "Igishushanyo", Shyira akamenyetso ku buryo bukwiye bwo gusimbuza amahame no kureba ibisubizo mumeza.



5. Ako kanya, fungura igice hagati kiboneye uburyo bwo guhindura imiterere yishusho. Mubaze ihumure, kontour kandi ugenera imiterere mugihe bibaye ngombwa. Ntiwibagirwe gukurikirana impinduka mu mbonerahamwe hanyuma ukabahagarika niba udakunda ikintu.

Hindura intera iri hagati yumurongo wibishushanyo

Muri menu imwe, gukorana nigishushanyo mbonera hariho imiterere itandukanye ifungura binyuze muri "ibipimo byigice". Irashinzwe kwiyongera cyangwa kugabanuka mu cyuho hagati yumurongo wimbere kuruhande rumwe. Hitamo intera nziza wimura urusigi. Niba bitunguranye gushiraho bidakwiranye, subiza indangagaciro zisanzwe (150%).

Guhindura aho ishoka

Igenamiterere ryanyuma rizaba ingirakamaro mugihe ukorana nigishushanyo cyigihe - hindura aho ishoka. Ihindura umurongo wa dogere 90, kora kwerekana igishushanyo mbonera. Mubisanzwe, mugihe ukeneye gutegura ubwoko busa, abakoresha bahitamo ubundi bwoko bwibishushanyo, ariko rimwe na rimwe urashobora guhindura gusa imiterere yiyi.

1. Kanda kuri Axis iburyo bwimbeba.



2. Ibikubiyemo biragaragara uko ufungura idirishya rya axis.



3. Muri yo, jya kuri tab yanyuma hamwe nibipimo.



4. Kwagura igice cya "Umukono".



5. Binyuze mu "mwanya wo mu rwego rwo gusiga" kumanuka, hitamo aho wifuza, kurugero, hepfo cyangwa hejuru, hanyuma urebe ibisubizo.