Sezvo histogram muna Excel

The yakanaka chichapedza anoshandura mashoko ari tafura Achawedzera histogram. Nyorai chati anokwanisa kuipa User kupfuura inokosha zvinoreva tsika zvose, kunyange pasina kuaverenga.

Nyaya vachapiwa namambo mumwe chete dzakaparara histogram muna Excel. How kuzviita, uchadzidza pakuguma kuverenga nyaya. Uyezve, ichapindura ose nuances dzinomuka munguva kuvakwa. Uyewo, uchadzidza anenge mana zvokusarudza siyana iripo kuratidza sei kuvaka histogram muna Excel.

Options nokuti pamasikiro histogram mu "Excel"

The inonyanya kufarirwa tafura mupepeti chinopa pfungwa dzinotevera kuti histogram kuvaka:

• nyore bhaa girafu;
• histogram pamwe kuwanda;
• kushandisa kuongorora pasuru;
• pamwe zvimiso formatting masero.

Zvino zvinofanira kucherechedzwa kuti vose pamusoro embodiments ingangoumbwa ari chinhu tafura vakaparadzana kana kuva chikamu chacho. Zvino ngationei anozodzidza kuongorora sei histogram muna Excel.

Nzira 1: A nyore histogram

A nyore bhaa girafu muna Excel iri kupfuura inowanzoshandiswa. kuvaka Its Hazvidi nguva yakawanda, uye muitiro hakurevi zvakadzama zivo chirongwa.

Pakutanga, kukosha kuisa parutivi vari patafura Data dzichashandiswa muna purogiramu mune ramangwana. Ipapo iwe unofanira kuenda Tab "Insert" uye tinya "Charts". Izvi anozarura submenu nezvirwere zvose zvinowanikwa pamusoro charts. Muchiitiko chino, tapota tinya Tab "Histogram" iri donhwe-pasi Muterere, sarudza kuti ndezverudzii. Zvinokosha kucherechedza kuti pane mumwe musara nyore histogram kutanga kuuya, vapedza atorongera pamwe kuunganidza histogram.

Saka mangoti iwe tinya iwe aida chati iri chimedu chirongwa rinowanika zvakananga chati pamwe nemashoko kare munzvimbo dzakasarudzwa.

Heino imwe histogram muna Excel. Sei kuti chinyorwa mairi, uchadzidza gare gare. Nepo kureva kuti zvimwe zvinogona kuitwa kushandisa zvokushandisa zviri boka Tabs "Kushanda Charts".

Method 2: Histogram pamwe kuwanda

Ndiani ichakurukurwa nzira kuratidza sei yokuvaka tinofanira kugara histogram muna Excel. Example unogona kuona munyaya ino.

Chokwadi chawo zvakasikwa hapana chakasiyana zvidiki, asi pane caveat inofanira jekesa. Asati kushanda pamwe histogram unofanira kubvisa zita rokutanga mbiru, kana pane mumwe, zvikasadaro hazvishandi.

Zvino unogona kusika. Kungofanana muzvirevo nzira, zvakakodzera govera chikamu tafura humboo dzichashandiswa pakuvaka. Zvadaro kuenda Tab "Insert" pamusoro Toolbar donhwe-pasi Muterere "Charts" anotaura kunongedzera "Histogram" uye zvadaro sarudza kuchengetera mhando. Zvinokosha kuyeuka kuti mumutsara mumwe nomumwe, riri kurutivi rworudyi.

Pashure nekudzvanya parimwe zvinhu pachikwata achava runoenzanirana tinofanira kugara histogram muna Excel.

Kufanana kokupedzisira, purogiramu, unogona ukachinja vachishandisa zvombo boka Tab "Kushanda Charts". Panzira, zvose zviitiko, kuchinja Chikwata ari chati, iwe chete vanofanira achizviendesa kaviri watinya pairi uye sarudza zita idzva.

Nzira 3: Kushandisa ongororo pasuru

Kubva nzira zvenhando kuti chinja chokuti kwakaoma. vanhu vashoma vanoziva kuti achibatsirwa yepurogiramu kuwedzera-Ons anogona histogram, asi zvinogona kuitwa.

Danho rokutanga kupinda pachavo vari superstructure. Kuti aite izvi, tinya Tab "File" uye sarudza sidebar chinhu "Settings". Next, kupinda muchikwata che "Wedzerai-Ons".

Ona donhwe-pasi mazita "Management". Mariri unofanira sarudza "Excel Add-Ons" uye baya "Enda" bhatani. Wedzerai-Ons hwindo ngapaonekwe. Chiisei ari gupa padivi "Analysis ToolPak" uye baya 'OK ".

Zvino dzokera tafura yako, sarudza mashoko anenge nzvimbo, uye wasarudza Tab "Data". In Tab ichi unofanira tinya "Data Analysis", riri mu "Analysis".

Pahwindo inooneka, sarudza kubva pamazita "Histogram" uye zvadaro achizviendesa "OK" - hwindo vachaonekwa yauri kuda kuisa parameters. Mu "Inzwa Zvinotaurwa siyana" vanofanira kupiwa umboo nzvimbo patafura. Kana uri kwerubwinyo rwakagara rwuripo dzinounzwa izvozvo, mutengo zvichabviswa akapinda kwaita. Next, tarisa bhokisi padivi "Ratidza zvakajeka" uye chete pamusoro pokuti izvi nenguva kuti kurega. Maererano zvabuda, tinya "OK" bhatani.

Nzira 4: ndokunge formatting masero

Kuti vagadzire histogram saizvozvi, unofanira kusarudza nzvimbo mashoko uye "Home" Tab, tinya "CONDITIONAL formatting". Mugore donhwe-pasi Pamazita, kufambisa cursor kuti "Histogram" iri Muterere, sarudza mumwe kufarira girafu mhando.

Pashure paizvozvo, sero mashoko azere pose - iri histogram. Sezvaungaona fembera, pakafunuka anoratidza uremu quantitative mashoko zvirimo.

mhedziso

Ndivo nzira ina idzo wagadzira chidimbu girafu muna Excel. vose vakanaka kwavowo uye akakodzera zvinodiwa zvakasiyana, saka tarisa zvose uye kusarudza zvinodiwa.