Uburyo bwo kongeramo umugani mu mbonerahamwe ya Excel 2011

Muri Microsoft Office Crosl, urashobora kubaka byihuse igishushanyo kumeza array kugirango ugaragaze ibiranga nyamukuru. Igishushanyo gikorwa kugirango wongere umugani kugirango uranga amakuru yerekanwe, ubahe izina. Iyi ngingo ivuga uburyo bwo kongeramo umugani muri chart muri Excel 2010.

Uburyo bwo kubaka imbonerahamwe iri hejuru kumeza

Icya mbere, birakenewe kumva uburyo igishushanyo cyubatswe muri gahunda usuzumwa. Inzira yo kubaka igabanijwe mu ntambwe zikurikira:

1. Mumeza yinkomoko, hitamo urwego rwifuzwa, inkingi ziterwa nazo zigomba kugaragara.

Hitamo urwego rusabwa mumeza kugirango wubake imbonerahamwe

1. Jya kuri tab "shyiramo" mubishushanyo byo hejuru ya menu nkuru ya gahunda.
2. Muri "diagram" block, kanda kuri kimwe mu bishushanyo mbonera byerekana igishushanyo mbonera cya array. Kurugero, urashobora guhitamo uruziga cyangwa imbonerahamwe.

Ibikorwa byo kubaka imbonerahamwe muri Excel 2010

1. Nyuma yo kurangiza ibikorwa byabanjirije, idirishya hamwe nigishushanyo cyubatswe kigomba kugaragara kuruhande rwisahani yumwimerere kuri excel. Bizagaragaza kwishingikiriza hagati yindangagaciro zifatwa nkibikorwa. Umukoresha rero arashobora kwerekana neza itandukaniro ryindangagaciro, gusesengura ingengabihe hanyuma usoze.

Uburyo bwo kongeramo umugani muri chart muri excel 2010 muburyo busanzwe

Ubu ni uburyo bworoshye bwo kongeramo umugani udafata umukoresha umwanya munini wo kubishyira mubikorwa. Ishingiro ryuburyo ni ugukora intambwe zikurikira:

1. Kubaka igishushanyo kuri gahunda yavuzwe haruguru.
2. Ibumoso bwa Manipulator kanda igishushanyo cyatsi kibisi mugikoresho cyintoki iburyo bwigishushanyo.
3. Muburyo bwavuzwe haruguru idirishya rifungura kuruhande rwumugani, shyira akamenyetso kugirango ukore imikorere.

Gukoresha akamenyetso kuruhande kumurongo "umugani" kugirango werekane kuri gahunda yubatswe

1. Gisesengura igishushanyo. Igomba kongeramo imikono yibintu biva kumeza yinkomoko.
2. Nibiba ngombwa, urashobora guhindura aho gahunda. Kugirango ukore ibi, kanda LKM kumugani hanyuma uhitemo ubundi buryo bwo ahantu hose. Kurugero, "ibumoso", "hepfo", "hejuru", "iburyo" cyangwa "hejuru yibumoso".

Guhindura aho igishushanyo kiri muri blok ku idirishya ryiburyo

Nigute wahindura inyandiko yumugani muri chart muri Excel 2010

Kuzigama umugani, niba ubishaka, birashobora guhinduka mugushiraho imyandikire ikwiye. Urashobora gukora iki gikorwa ukurikije amabwiriza akurikira:

1. Kubaka igishushanyo hanyuma wongere umugani kuri algorithm yaganiriye hejuru.
2. Hindura ingano, imyandikire yimyandikire kumeza yinkomoko, muri selile gahunda ubwayo yubatswe. Iyo ushimangiye inyandiko mu nkingi yimeza, inyandiko iri mumigani yimbonerahamwe izahita ihinduka.
3. Reba ibisubizo.

Uburyo bwo kuzuza imbonerahamwe

Usibye umugani, hari andi makuru menshi ashobora kugaragara kuri gahunda yubatswe. Kurugero, izina ryayo. Kwita ikintu cyubatswe, ni ngombwa gukora ku buryo bukurikira:

1. Wubake igishushanyo ku isahani yinkomoko hanyuma wimuke kuri tab "imiterere" hejuru ya porogaramu nkuru.
2. Agace kakazi hamwe nigishushanyo bizakingura, muribipimo byinshi biboneka kugirango bihinduke. Muri ibi bihe, umukoresha akeneye gukanda kuri "igishushanyo cya"
3. Murutonde rwagutse rwamahitamo, hitamo ubwoko bwubwoko bwaho. Irashobora gushyirwa hagati hamwe no kurengana, cyangwa hejuru ya gahunda.

Ongeraho imitwe ku mbonerahamwe yo mu biro bya Microsoft Excel

1. Nyuma yo gukora manipulations yabanjirije, igishushanyo "kigaragara ku gishushanyo cyubatswe. Umukoresha wacyo azashobora guhinduka, guha agaciro intoki kuva kuri clavier ubundi buryo bwo guhuza amagambo akwiriye mubisobanuro kumeza yinkomoko array.

Guhindura byongewe ku izina ryizina

1. Ni ngombwa kandi gusinya umurongo ku mbonerahamwe. Biyandikishije muri ubwo buryo. Mubikorwa byakazi hamwe nimbonerahamwe, uzakenera gukanda kuri buto "ya AXIS". Murutonde rutaragaragara, hitamo imwe mushobano: haba ahantu hahagaritse cyangwa utambitse. Ibikurikira, kora impinduka zikwiye kumahitamo yatoranijwe.

Gusinya ishoka mu mbonerahamwe

Ubundi buryo bwo guhindura imbonerahamwe ya Legend muri Excel

Urashobora guhindura inyandiko yimikono kuri gahunda ukoresheje igikoresho cyubatswe muri gahunda. Kugirango ukore ibi, ugomba gukora intambwe nke zoroshye kuri algorithm:

1. Iburyo-urufunguzo Manipulator Kanda kumagambo yifujwe umugani wimbonerahamwe yubatswe.
2. Mu idirishya ryidirishya, kanda umurongo wa "muyunguruzi". Nyuma yibyo, idirishya ryuyunguruzi.
3. Kanda kuri buto ya "Hitamo amakuru", iherereye hepfo yidirishya.

Umugani Ibiranga Idirishya muri Excel

1. Muri menu nshya "hitamo amakuru yamakuru", ugomba gukanda kuri "impinduka" mumodoka "umugani".
2. Mu idirishya rikurikira muri "Izina ryumurongo", uzondikisha izina ritandukanye kubintu byatoranijwe mbere hanyuma ukande kuri "Ok".

Kwandika izina rishya kubintu

1. Reba ibisubizo.

Umwanzuro

Rero, kubaka umugani muri Microsoft Office Excel 2010 bigabanijwemo ibyiciro byinshi, buri kimwe muricyo gikeneye ubushakashatsi burambuye. Niba ubishaka, amakuru yerekeye imbonerahamwe arashobora guhindura byihuse. Hejuru Amategeko shingiro yakazi hamwe nimbonerahamwe muri Excel zasobanuwe.

Ubutumwa uburyo bwo kongeramo umugani mu mbonerahamwe ya Excel 2011 yagaragaye mbere yikoranabuhanga.