Hlahisa Data ea Chart le Exploding Pie Charts ka Excel

Excel e na le dikgetho tse 'maloa bakeng sa ho phaella ka ho hatisa ho likarolo tse itseng kapa likarolo tsa chate ea pie e sa akarelletseng ho fetola kapa ho hlophisa boitsebiso ba chate. Tsena li kenyelletsa:

• ho phatloha kapa ho ntša sekhetho se khethiloeng ho tsoa ho e 'ngoe ea pie;
• ho tsepamisa mohopolo o le mong kapa ho feta ho sebelisa lekareche la Pie ;
• ho tsepamisa mohopolo o le mong kapa ho feta ho sebelisa mokha oa Bar oa Pie .

Ho senya sekhao se le seng sa Pie

Ho eketsa ts'ebetso e itseng ea chate ea pie u ka falla kapa ua "phatloha" sengoathoana sena ho tloha kahare ho chate kamoo ho ka bonoang ka lehlakoreng le letšehali la setšoantšo ka holimo.

Ho etsa sena:

1. Tobetsa ka lekhetlo le le leng ka pointer ea mouse holima sebaka sa mohaho oa chate ea pie ho e totobatsa - li-circular tse nyenyane tsa bluse kapa matheba a mabeli a lokela ho bonahala ho pota-potiloe ka ntle ho pie;
2. Tobetsa ka lekhetlo la bobeli serapeng se lokelang ho phatloha;
3. Hona joale matheba a lokela ho pota-pola sekhao sena se le seng sa pie - ho kenyelletsa letheba ho bohareng ba chate;
4. Tlanya le ho hula ka pointer ea mouse ho slice e khethiloeng ea pie, ho e hula kapa ho e senya hōle le setseng eohle;
5. Ho tlosa sekhahla se phatlohileng sebakeng sa eona sa pele, sebelisa setšoantšo se hlalosang Excel haeba ho khoneha;
6. Haeba ha ho joalo, pheta mehato ea 1 le 2 ka holimo ebe u hulela sekhae ho pie. E tla khutlela sebakeng sa eona sa pele.

Ho senya Pie eohle

Haeba likarolo tsohle tsa chate li phatloha ho bolela hore ha ua khetha sekhahla se le seng feela. Ho lokisa sena, hula likhae hammoho 'me u leke mehato ea 2 le 3 ka holimo hape.

Pie ea Pie le Bar ea Li-Charte

Ntho e 'ngoe ea ho phaella ka ho hatisa likarolong tse itseng tsa chate ea pie ke ho sebelisa phae ea pie kapa sethala sa chate ea pie ho e-na le chate ea kamehla ea pie.

Haeba u na le likhaephe tse peli kapa tse kholo tse laolang chate ea pie, e leng ho etsang hore ho be thata ho bona lintlha tsa lintlanyana tse nyenyane, fetisetsa ho e 'ngoe ea mefuta e' meli ea chate, e hatisang lintlanyana tse nyenyane ka lebokoseng la bobeli - ebang ke lecha ea bobeli ba pie kapa chate e entsoeng ka mohala, khetho ke ea hau.

Ntle le ho fetoha, Excel e tla kenyelletsa ka ho hlaka lintlha tse tharo tse nyenyane ka ho fetisisa ( lintlha tsa data ) phapeng ea pie kapa stack bar.

Ho etsa phae ea pie kapa mochini oa chate ea pie:

1. Totobatsa lintlha tse ngata tse lokelang ho sebelisoa ka chate;
2. Tobetsa ho kenya Taba ea lithane ;
3. Ka lebokose la Charts la lithane, tobetsa letšoao la Insert Pie Chart ho bula menyetla e theoha ea mefuta ea lichate e fumanehang;
4. Tlosa pointer ea mouse holima mofuta oa chate ho bala tlhaloso ea chate;
5. Tobetsa ka pie kapa pie ea chate ea pie karolong ea 2-D ea Pie ea menu e theohelang ho kenya lengolo mosebetsing.

Tlhokomeliso: Chate e ka letsohong le letšehali e ntse e le chate e kholo, le chate e bobeli e hlaha ka letsohong le letona. Tokisetso ena e ke ke ea fetoloa.

Mefuta ea Chate

Ho chencha ho tloha mokateng o tloaelehileng oa pie ho ea ho phae ea pie kapa mochini oa chate ea pie :

1. Tobetsa ka ho le letona chate e teng hona joale ho bula menyetla ea moelelo;
2. Lenaneng, tobetsa Mofuta oa Taba oa Chart ho bula lebokose la bocha la lebokose la Taba ea Chart ;
3. Ka lebokoseng la lebokose, tobetsa Tobane ea Likarete Tsohle ;
4. Tobetsa ho Pie ka letsohong le letšehali, ebe o tobetsa Pie ea Pie kapa Bar of Pie ka letsohong le letona ho lebokose la lebokose.

Ho fetola Palo ea Lintlha tsa Boitsebiso

Ho fetola palo ea lintlha tsa lintlha (likhae) tse bontšitsoeng ka lebokoseng la bobeli:

1. Tlanya ka letsoho lehlakoreng le leng chate (data e sebelisetsoang ho etsa lecha la bobeli) ho bula Format Data Series pane;
2. Kamoreng e kahare, tobetsa motsu o ka tlase ho Sehlabelo sa Split ka kgetho.

Likgetho tse amanang le ho fetola palo ea lintlha tsa lintlha ka lebokoseng la bobeli ke tsena:

• Arola lihlooho ka boemo : ka Melao-motheo ea lebokoseng la bobeli la morero , kenngoa palo ea maemo kapa likarolo tse bontšitsoeng ka lebokoseng la bobeli - 3 bonyane;
• Arola lihlopha tsa boleng : Melao ea bohlokoa ho feta lebokose, kenya nomoro e kholo ho feta e nyenyane ka ho fetisisa ea data e lokelang ho bontšoa ka lebokoseng la bobeli;
• Arola lihlooho ka palo ea peresente : ho Melao ea boitšoaro e ka tlase ho lebokose, kenngoa phaello ea peresente pakeng tsa 0% le 100% - boleng bona bo amana le karolo ea palo e kholo ea chate e lokelang ho bontšoa ka lebokoseng la bobeli.