How kuvaka histogram muna Excel uye neShoko

Hapana angadai nharo ndechokuti histogram - yakanaka chishandiswa nemaziso kuratidza mashoko. Just akatarira chati, zvinokwanisika munguva pfupi nguva kuongorora mamiriro pasina kushandisa kuongorora kusanganiswa tsika iri tafura. Ndokusaka nyika akakurumbira spreadsheet mupepeti "Excel" akatora mudziyo maoko.

Munyaya ino uchadzidza sei kuvaka bhaa girafu muna Excel. Pane ina nzira rokuvaka disassembled, mumwe nomumwe iri zvakakwana siyana pakati pachavo. Naizvozvo zvakakodzera kupedza kuverenga nyaya kusvikira pakuguma, kusarudza nzira pachavo. Panoperera nyaya achava muenzaniso histogram mu "Shoko."

histogram

In Excel, zvinokwanisika kuvaka histogram nzira nhatu:

• kushandisa chaiyo turusi;
• Kushandisa ndokunge formatting;
• pamwe wedzera-Ons.

Zvino isu kutarira zvose nzira kuvaka histogram muna Excel. Nenzira, rinogona kuitwa kubva munzira dzakasiyana - kuva chikamu sero chaiwo kana yoga chinhu.

nzira rokutanga; pavakwe kwakajairika histogram

Construction kunotanga yavaive tafura nzvimbo, kukosha izvo zvichashandiswa uratidzwe mune ramangwana histogram. Kamwe Kusarudza yave ichiitwa, unofanira kuenda Tab "Insert". Zvakakodzera tinya "Histogram" bhatani, riri mu "Mifananidzo".

Pakupedzisira, pamberi penyu ndizvo ndandanda apo unofanira kusarudza mumwe charts. Nenzira, zvatinosiita histogram rinowanika wokutanga pamazita.

Pashure kuvasarudza muna Excel ichava kutsvakwa sarudzo, uye iri kuvaka inogona kunzi sezvo apera. Zvisinei, unogona aongorore histogram, achishandisa zvishandiso zviri boka Tabs vanoda "Kushanda Charts".

Wechipiri nzira: kuvakwa kuunganidza

Somuzana nzira yokutanga, tinofanira akazvitsaurira tafura. The histogram mune iyi yakavakwa zvishoma zvakasiyana. Chinhu chokutanga unofanira kuteerera - ndiwo zita iri Header: havafaniri kuva. Zvikasadaro, hapana chinoitika.

Mushure kusarudzwa unofanira kuenda Tab "Insert", tinya "Charts" iri donhwe pasi Muterere "Histogram" kusarudza iwe kufarira. Zvinokosha kucherechedza kuti histogram kuwanda vari kurudyi chikamu pasi.

By kusarudza mumwe zvinhu, ona purogiramu musi papepa. The histogram, sezvo ari yapfuura muitiro inogona kuchinjwa panguva nokungwara kwako, naizvozvowo kushandisa maturusi, izvo riri boka Tabs "Kushanda Charts".

Chechitatu nzira: kuvakwa kushandisa wedzera-Ons

Zvino isu ita nzira yechitatu sei kuvaka histogram. Inoitwa kushandisa chinokosha kuongorora pasuru.

Danho rokutanga kuti Activate kuti pasuru. Kuti aite izvi, unofanira pakutanga chirongwa tinya "File" bhatani. Zvadaro sidebar kuenda "Settings" chikamu. Zvino, kuwana chinhu "Wedzerai-dzi" iri donhwe-pasi Muterere "Control" sarudza "Excel Add-dzi." Zvadaro baya "Enda" bhatani.

Unove wedzera-dzi bhokisi umo unofanira kuisa gupa padivi "Analysis ToolPak" uye baya 'OK "bhatani.

Nokudaro, kuongorora pasuru iri kusashanda. Zvino histogram rinoitwa mu "Data" - enda ikoko.

On the Toolbar, unofanira achizviendesa "Data Analysis", iri parutivi rworudyi mu "Analysis". A hwindo anozviratidza umo zvaunoda kutaura "Histogram" uye zvadaro achizviendesa "OK" bhatani.

Izvi zvichaita kuzarura imwe hwindo apo unofanira kuisa pamberi parameters zveramangwana yacho chati. Mu "Inzwa Zvinotaurwa siyana" unofanira kutaridzwa nzvimbo patafura, apo mashoko richashandiswa kuvakwa. Pashure paizvozvo, tarisa bhokisi padivi "Display Graphics". Zvino unogona chete zvakanyatsonanga apo chati zvichabviswa kuratidzwa. Kune zvitatu - a workbook itsva, pepa itsva kana pamusoro jira. Pashure mezviruva iri, achizviendesa "OK" bhatani.

Maererano kunoguma yenyu iine nzvimbo histogram girafu unoratidzwa.

Nzira yechina: kuvaka chete ndokunge formatting

Nzira yechina ndiyo kuvaka histogram, Evhangeri yemvura noMweya ndiyo vose pamusoro akurukurwa. Panoperera ongororo yake, uchaona unozviunganidzira ichi.

Pakutanga, sapamazuva dzekare, unofanira kusarudza nzvimbo patafura, apo mashoko richashandiswa kuvakwa. Kana aita izvi, uende "Home" pamusoro Toolbar, svinudzai donhwe-pasi mazita "CONDITIONAL formatting". Mariri unofanira kuwana chinhu "Histograms" uye kunoguma hwindo, sarudza zvaimirirwa histogram. Kune miviri zvokusarudza: a gradient zadza uye yakasimba. Musiyano mavari zvachose hapana hapana, saka kuti iwe unogona kufunga kwako kuravira pakusarudza.

Kamwe iwe sarudza rudzi histogram, izvozvo vachaonekwa mumasero zvakananga ari muchimiro zvekupfakira mutsetse.

Histogram mu "Shoko"

Zvino ngationei sei kuita histogram mu "Shoko." At paro, muitiro waro zvakasikwa haana zvikuru rakasiyana "Excel", asi zvinhu zvokutanga pakutanga.

Pakutanga, sarudza nokutsikirira kuruboshwe negonzo bhatani, nzvimbo uchida vemabhuku histogram. Pashure paizvozvo, enda Tab "Insert" uye mu "Pictures", tinya "Insert Chart" bhatani - iri runoenzanirana hwindo ngapaonekwe.

Muna sidebar bhokisi, sarudza mashoko category "Histogram," uye kurudyi, tsanangurai zvaimirirwa histogram. Sezvaunogona kuona, pane zvose zvavo uye mari - kusarudza zvakanaka uye achizviendesa "OK" bhatani.

On a Pepa "Ward" histogram wako anooneka. Cherechedza kuti pasi richava chiduku "ekselevskaya" tafura date mukova. Isa raida variables, uye kunakidzwa mugumisiro.

Zvino kuti munoziva kuti histogram mu "Shoko." Zvinofanira kucherechedzwa, hachisi akaoma kupfuura "Eksele".