Simbisa Dhairi Dhavhiro Neku Exploding Pie Charts mu Excel

Excel ine nzira dzakasiyana-siyana dzekuwedzera kuwedzera kune zvikamu zvakasiyana kana zvimedu zve chati yepadhi isingasanganisi kuchinja kana kugadzirisa zvakare data data. Izvi zvinosanganisira:

• kuputika kana kukwevera slice yakasarudzwa kubva kune imwe pese;
• kutarisa imwe kana kupfuura zvisi zvichishandisa Pie of Pie chati;
• vachitarisa imwechete kana kupfuura zvimedu vachishandisa Bhar of Pie chati.

Kubvambura Slice Rimwe Chete

Kuti uwedzere kusimbiswa kune chimwe chidimbu che chati ye pie iwe unogona kufamba kana "kuputika" ichi chikamu kubva kune imwe sarati sezvazvinogona kuonekwa kurutivi rworuboshwe rwemufananidzo pamusoro apa.

Kuita izvi:

1. Dzokorora kamwechete neine mouse pointer panzvimbo yenzvimbo ye chati ye pie kuti uise pachena - maduku maduku emabluish kana madotsiti anofanira kunge achionekwa nepamusoro pekunze kwepiyo;
2. Dzvanya kechipiri pane tsanga inoputirwa;
3. Mavara acho zvino anofanira kukomberedza chidimbu chimwechete chechira - kusanganisira dot mukati mechati;
4. Dzvanya uye dhonza nemuongorori weguru pane sarudzo yakasarudzwa ye pie, kuchibudisira kunze kana kuiputira kunze kwechase che chati;
5. Kuti ushandise chikamu chakaputika kudzokera kunzvimbo yayo yepakutanga, shandisa shanduro yeExcel kana zvichibvira;
6. Kana zvisingaiti, dzokorora matanho 1 ne2 kumusoro ndokukwevera slice kumashure. Ichazodzokera kunzvimbo yayo yepakutanga.

Kubvambura Pie Yese

Kana zvikamu zvese zviri mu chati zvichiburika zvinoreva kuti iwe hauna kusarudza saga imwe chete. Kugadzirisa izvi, dhonza zvimedu zvakare pamwe chete uye edza matanho 2 ne3 kumusoro zvakare.

Pie of Pie neBar of Pie Charts

Imwe nzira yekuwedzera inowedzera kune dzimwe nhengo dze chati yepayiri ndeyekushandisa pie ye pie kana bhora yepayipi chati pane cheta yenguva dzose.

Kana uine imwe kana maviri mapetanga makuru anotungamira chati yepayiri, zvichiita kuti zvive nyore kuona tsanangudzo dzezvidimbu zviduku, shandura kune imwe yemhando mbiri idzi, iyo inowedzera zviduku zviduku mune chechipiri chechipiri - kana chechi yechipiri kana bhata rakaiswa bhora, chisarudzo ndechoko.

Kunze kusina kuchinjwa, Excel ichabatanidza zvinyorwa zvitatu zviduku ( data points ) muchidimbu chechipiri kana chevha yebhadha.

Kugadzira pie ye pie kana bharati yekapeta chati:

1. Simbisa ruzivo rwemashoko kuti rushandiswe mu chati;
2. Dzvanya pa Inser tab yebhoni ;
3. Muchikwata cheCharts yebhoni, tsvaga paIndaneti Pie Chart yekuti uzarure mhando yezvinyorwa zvinowanika mazera echati;
4. Hover your mouse pointer pamusoro pechati chinonzi kuverenga tsanangudzo yechati;
5. Dzvanya pane pie ye pie kana bharati yechati chechirasi muchikamu chechipiri cheDe-D chekuderera pasi kuti uwedzere iyo chati kumushandi webasa.

Cherechedza: Kuruboshwe-chati chati nguva dzose ndiro chati huru, uye chati yechipiri nguva dzose ichioneka kurudyi kwayo. Urongwa uhwu haugoni kuchinjwa.

Kushandura Chati Mhando

Kugadziridza kubva pane imwe yadhidhiyo yepayiri yagara iripo kusvika kune pie ye pie kana bharha yechayoti chati:

1. Sarudza pakarurama pane chati iripo kuti uzarure mamiriro ekutenderera;
2. Mune menyu, chengetedza Purogiramu yeChirati yeKushandura kuti uzarure Bhokisi reKushandura Chetabhenji Chebhokisi;
3. Mubhokisi rebhokisi, chengeta paZvose Dhairiti tab;
4. Dzvanya paPie kuruboshwe-kuruboshwe, uye pfuurira paPie of Pie kana Bhar of Pie muboshwe-pane pane bhokisi rebhokisi.

Kuchinja Nyaya Yezvinyorwa Zvitsva

Kushandura nhamba yematafura (zvimedu) zvakaratidzwa muchidimbu chechipiri:

1. Tsanangurira pane imwe chikamu mu chati (data inoshandiswa kugadzira chikamu chechipiri) kuti uzarure Format Data Series pane;
2. Muchikamu, chengetedza museve pasi pedyo neSplit Series nechisarudzo.

Zvisarudzo zvine chokuita nekuchinja nhamba yematafura ekudhindwa kune chechipiri ndeyokuti:

• Paridzai nhungamiro nechinzvimbo : mumitemo yebhokisi rechipiri bhokisi, pinda nhamba yezvigaro kana zvidimbu zvakaratidzwa muchidimbu chechipiri - 3 zvishoma;
• Paridzai nhepfenyuro neKubatsira : mumitemo isiri pasi pebhokisi, pinda nhamba iyo yakakura kudarika duku kudarika inonyanya kuiswa mune chechi yechipiri;
• Paridzai nhepfenyuro ne Percentage value : mumitemo isiri pasi pebhokisi, pinda pazana yepakati pakati pe 0% ne100% - kukosha uku kunopindirana nemapatendi echinyorwa chairo chakakosha kuti chiratidzwe mune chechi yechipiri.