Uburyo bwo kubaka umurongo muri excel

Kimwe mubice byingenzi byisesengura byose ni ukumenya inzira nyamukuru yibyabaye. Kugira aya makuru birashobora kuba ibyateganijwe kugirango habeho iterambere ryibihe. Ibi bigaragarira cyane cyane kurugero rwumurongo ukomoka kuri gahunda. Reka tumenye uburyo muri gahunda ya Microsoft Excel ushobora kuyubaka.

Umurongo wa Tress muri Excel

Porogaramu ya Excel itanga ubushobozi bwo kubaka umurongo hamwe nigishushanyo. Mugihe kimwe, amakuru yambere yo gushiraho yakuwe kumeza yabanjirije.

Gushushanya

Kugirango wubake imbonerahamwe, ugomba kugira ameza yiteguye, hashingiwe kuriyo. Nkurugero, dufata amakuru ku gaciro k'amadolari mu mafaranga mugihe runaka.

1. Twubaka ameza aho mu nkingi imwe izaba ibice byigihe gito (mugihe cyacu cyamatariki), no mubindi - agaciro, imbaraga zizerekanwa kwerekanwa mubishushanyo.



2. Hitamo iyi mbonerahamwe. Jya kuri tab "shyiramo". Ngaho kuri kaseti muri "igishushanyo" cyo guhagarika kanda kuri buto "Gahunda". Kuva kurutonde rwatanzwe, hitamo inzira yambere.



3. Nyuma yibyo, gahunda izubakwa, ariko igomba gukomeza kunonosorwa. Dukora umutwe w'igishushanyo. Kubwibi, kanda kuri yo. Muri "akazi hamwe nimbonerahamwe" tab igaragara, jya kuri tab "imiterere". Muri yo, kanda kuri "Igishushanyo Umutwe". Kurutonde rufungura, hitamo ikintu "hejuru yigishushanyo".



4. Mu murima wagaragaye hejuru ya gahunda, winjiza izina tubona ko rikwiye.



5. Noneho dusinyira axis. Muri tab imwe "imiterere" imwe, kanda kuri buto kuri "Axis Izina" kaseti. Guhora unyura mubintu "izina ryinshi rya horizontal axis" n "" izina munsi ya axis ".



6. Mu murima ugaragara, andika izina rya horizontal axis, ukurikije imiterere yamakuru ahoho.



7. Kugirango dushyirire izina rya axis yahagaritse, dukoresha kandi "imiterere". Kanda kuri Button "IZINA REXES". Turahora tugenda kubintu bya pop-up menu "izina ryinyuguti nkuru" n "" izina rizunguruka ". Ubu bwoko bwizina rya axis buzaba ryoroshye cyane kuburyo bwiza bwibishushanyo.



8. Mugihe cyagaragaye hagati yizina rya axical axis andika izina ryiburyo.

Isomo: Nigute ushobora gukora igishushanyo muri excel

Gukora umurongo

Noneho ukeneye kongeramo mu buryo butaziguye.

1. Kuba muri tab "imiterere" ukanze kuri buto "umurongo wa Trend", uherereye mubikoresho bya "isesengura". Uhereye kurutonde rutangira, hitamo ikintu "cyerekana ibimenyetso" cyangwa "umurongo ugereranya".



2. Nyuma yibyo, umurongo wongeyeho kuri gahunda. Mburabuzi, ifite ibara ry'umukara.

Gushiraho umurongo

Birashoboka gukomeza guhindura umurongo.

1. Guhora ujya kuri tab "imiterere" kuri menu ya menu "Isesengura", "umurongo ugaragara" na "Ibipimo by'inyongera ...".



2. Idirishya rya Parameter rifungura, urashobora gukora igenamiterere ritandukanye. Kurugero, urashobora guhindura impinduka muburyo bworoshye no kugereranya uhitamo kimwe mubintu bitandatu:
   • Polinomial;
   • Umurongo;
   • Imbaraga;
   • Logarithmic;
   • Exponential;
   • Guhuza umurongo.

   Kugirango tumenye neza icyitegererezo cyacu, twashizeho amatiku yerekeye ikintu "shyira agaciro kagaciro keza kagereranijwe kagereranijwe." Kureba ibisubizo, kanda kuri buto "Gufunga".

   

   Niba iki kimenyetso ari 1, noneho icyitegererezo ni cyizewe gishoboka. Urwego rwaba kure kuri umwe, ntimwiringirwa cyane.

Niba udahaza urwego rwizewe, urashobora kongera kugaruka kubipimo hanyuma ugahindura ubwoko bwakorohewe no kugereranya. Noneho, kora hamwe.

Iteganyagihe

Igikorwa nyamukuru cyumurongo wuburyo nubushobozi bwo gukora ibyateganijwe kugirango habeho iterambere ryibyabaye.

1. Na none, jya kuri ibipimo. Muri igenamiterere rya "Fention" mubice bikwiye, tugaragaza uburyo igihe kirekire cyangwa inyuma gikeneye gukomeza umurongo werekana. Kanda ahanditse "gufunga".



2. Ongera ujye kuri gahunda. Byerekana ko umurongo urenze. Noneho urashobora kumenya icyerekezo cyagereranijwe cyahanuwe kumunsi runaka mugihe ukomeje inzira y'ubu.

Nkuko mubibona, Excel ntabwo bigoye kubaka umurongo. Porogaramu itanga ibikoresho kugirango bigerweho kugirango bigenwa kugirango bigabanye ibipimo. Ukurikije igishushanyo, urashobora gukora prognose mugihe runaka.