Kupanga histogram mu Microsoft Excel

A histogram ndi chida chachikulu chowonera. Ichi ndi chithunzi chojambula chomwe mungayang'anire momwe zinthu ziliri, pongoyang'ana, osasanthula kuchuluka kwa zinthu patebulopo. Pali zida zingapo mu Microsoft Excel zopangidwa kuti zimange mitundu yosiyanasiyana ya ma histogram. Tiyeni tiwone njira zosiyanasiyana zomangira.

Phunziro: Momwe mungapangire histogram mu Microsoft Mawu

Mbiri

Mutha kupanga histogram mu Excel m'njira zitatu:

• Kugwiritsa ntchito chida chomwe ndi gawo la gulu Ma chart;
• Kugwiritsa ntchito mawonekedwe
• Kugwiritsa ntchito phukusi lowonjezera la Analysis.

Itha kuponyedwa ngati chinthu chosiyana, kapena mukamagwiritsa ntchito makonzedwe, ngati gawo la khungu.

Njira 1: pangani mbiri yosavuta mu tchati

Mbiri yosavuta kwambiri yomwe imachitika mosavuta imagwiritsa ntchito chipangizocho Ma chart.

1. Timapanga tebulo lomwe lili ndi zomwe zikuwonetsedwa mu tchati chamtsogolo. Sankhani ndi mbewa mizere ya tebulo yomwe iziwonetsedwa pama axel a histogram.



2. Kukhala mu tabu Ikani dinani batani Mbiriili pa riboni m'bokosi la chida Ma chart.
3. Pamndandanda womwe umatsegulira, sankhani chimodzi mwa mitundu isanu ya zithunzi zosavuta:
   • histogram;
   • volumetric;
   • cylindrical;
   • conical;
   • piramidi.

   Zithunzi zonse zosavuta zili kumanzere kwa mndandanda.

   Chisankho chikapangidwa, histogram imapangidwa pa pepala la Excel.



Kugwiritsa ntchito zida zomwe zili pagulu latsamba "Kugwira ntchito ndi ma chart" Mutha kusintha chinthu chomwe chotsatira:

• Sinthanitsani masanjidwe;
• Saina dzina la tchati lonse, ndi nkhwangwa zake;
• Sinthani dzinalo ndikuchotsa nthano, ndi zina zambiri.

Phunziro: Momwe mungapangire tchati ku Excel

Njira 2: Kupanga histogram ndi kudzikundikira

Histogram yokhala ndi mizati yomwe imakhala ndi mfundo zingapo nthawi imodzi.

1. Musanayambe kupanga tchati ndi kudzikundikira, muyenera kuwonetsetsa kuti dzinalo kulibe mu mutuwo kumanzere kwenikweni. Ngati pali dzina, ndiye kuti liyenera kufufutidwa, apo ayi, kapangidwe ka chithunzicho sikugwira ntchito.



2. Sankhani tebulo pamunsi momwe histogram idzapangidwire. Pa tabu Ikani dinani batani Mbiri. Pa mndandanda wama chart omwe amawoneka, sankhani mtundu wa histogram ndi kudzikundikira komwe timafunikira. Onsewa ali kudzanja lamanja la mndandanda.



3. Pambuyo pa izi, histogram imawoneka papepala. Itha kusinthidwa pogwiritsa ntchito zida zomwe zidakambidwa pakufotokozera njira yoyamba yomangira.

Njira 3: pangani pogwiritsa ntchito “Analysis Package”

Kuti mugwiritse ntchito njira yopanga histogram pogwiritsa ntchito phukusi la kusanthula, muyenera kuyambitsa pulogalamuyi.

1. Pitani ku tabu Fayilo.



2. Dinani pa dzina la gawo "Zosankha".



3. Pitani pagawo laling'ono "Zowonjezera".



4. Mu block "Management" sinthani kusintha kwa malo Wonjezerani-Ex.



5. Pazenera lomwe limatseguka, pafupi ndi chinthucho Mapaketi Osanthula ikani chizindikiro ndikudina batani "Zabwino".



6. Pitani ku tabu "Zambiri". Dinani batani lomwe lili pa riboni "Kusanthula Kwambiri".



7. Pa zenera laling'ono lomwe limatsegulira, sankhani Mbiri. Dinani batani "Zabwino".



8. Zenera la histogram limatsegulidwa. M'munda Kulowetsa Kuyimitsa lowetsani adilesi yamagulu osiyanasiyana omwe maselo awo tikufuna kuwonetsa. Onetsetsani kuti mwayang'ana bokosi pansipa "Zithunzi. M'magawo okuthandizira, muthanso kudziwa komwe histogram ikawonetsedwa. Mosasamala - patsamba latsopano. Mutha kunena kuti zomwe mwatulutsa zizikhala patsamba ili m'maselo ena kapena m'buku latsopano. Pambuyo pazosintha zonse zalowa, dinani batani "Zabwino".

Monga mukuwonera, histogram imapangidwa kumalo omwe mudatchulawo.

Njira 4: Ma chart a Bar

Ma histogram amatha kuwonetsedwa ndi maselo akukhazikitsa.

1. Sankhani maselo omwe ali ndi zomwe tikufuna kupanga ngati histogram.
2. Pa tabu "Pofikira" pa tepi dinani batani Njira Zakukonzerani. Pazosankha zotsitsa, dinani chinthucho Mbiri. Pa mndandanda wa ma histogram omwe ali ndi mawonekedwe okhazikika komanso okongola omwe amapezeka, timasankha zomwe timaziona kuti ndizoyenera pankhani iliyonse.

Tsopano, monga mukuwonera, khungu lililonse lomwe lili ndi mawonekedwe limakhala ndi chisonyezo, chomwe mu mawonekedwe a histogram chimafotokoza kulemera kwa kuchuluka kwa data yomwe ilimo.

Phunziro: Zowongolera mu Excel

Tinatha kuwonetsetsa kuti purosesa ya tebulo la Excel imapereka mwayi wogwiritsa ntchito chida chophweka ngati histograms mwanjira yosiyana kotheratu. Kugwiritsa ntchito ntchito yosangalatsayi kumapangitsa kupenda ma data kuwoneka kwambiri.