Ka Microsoft Office Excel, o ka haha setšoantšo kapele ho holisoa ho bonahatsa litšobotsi tsa eona tsa sehlooho. Setšoantšo se etsoa ho eketsa lekhasi ho khetholla tlhahisoleseling e hlahisoang ho eona, li fe lebitso. Sengoliloeng sena se fumana mekhoa ea ho eketsa pale ho chate e sebetsang 2010.
Mokhoa oa ho aha chate e ipabolang tafoleng
Taba ea pele, ho bohlokoa ho utloisisa hore na setšoantšo se hahuoa joang lenaneong. Ts'ebetso ea kaho ea eona e arotsoe ka mokhoa o ikhethileng:
- Tafoleng ea mohloli, khetha lisele tse lakatsehang, likholomo tseo ho tsona ho lokelang ho li bonahala.
![Mokhoa oa ho kenyelletsa legend chart ea Excel 2010 1348_1](/userfiles/22/1348_1.webp)
- E-ea "ho kenya" tabo ho setšoantšo se ka holimo sa menyu ea sehlooho.
- "Setšoantšo sa" Setšoantšo se "tlanya ho e 'ngoe ea mefuta e fapaneng ea sesupo sa mofuta oa litsietsi. Mohlala, o ka khetha chate e chitja kapa bar chate.
![Mokhoa oa ho kenyelletsa legend chart ea Excel 2010 1348_2](/userfiles/22/1348_2.webp)
- Kamora ho qeta ketso e fetileng, fensetere e nang le setšoantšo se hahiloeng e lokela ho hlaha haufi le poleiti ea pele e potileng. E tla bonahatsa ho itšetleha pakeng tsa boleng bo nkuoang ka har'a letsopa. Kahoo mosebelisi a ka leboha haholo liphapang tsa boleng, sekaseka kemiso le ho fihlela qeto ea ho e fihlela.
Mokhoa oa ho kenyelletsa legend ho chate e sebetsang 2010 ka tsela e tsitsitseng
Ena ke mokhoa o bonolo ka ho fetisisa oa ho kenyelletsa lesela le se keng la nka mosebelisi nako e ngata ea ho kenya tšebetsong. Moelelo oa mokhoa ke ho etsa mehato e latelang:
- Haha setšoantšo se ka tatellano e kaholimo.
- Leqheka la senotlolo la Letsoho le tobetsa konopo ea Cent ea Cross Cross ho lisebelisoa ka letsohong le letona la graph.
- Foardfong ea likhetho tse kaholimo tse bulang haufi le thapo ea lerame, e behe matla a ho kenya tšebetsong mosebetsi.
![Mokhoa oa ho kenyelletsa legend chart ea Excel 2010 1348_3](/userfiles/22/1348_3.webp)
- Sekaseka setšoantšo. E lokela ho kenyelletsa li-sinchures tsa lintho tse tsoang modumo oa Taforōle ea mohloli.
- Haeba ho hlokahala, o ka fetola sebaka sa kemiso. Ho etsa sena, tlanya LKM ka selikalikoe ebe u khetha khetho e 'ngoe ea sebaka seo. Mohlala, "ka ho le letšehali", "ka tlase", "holimo", "ho le letona" kapa "ka letsohong le letšehali".
![Mokhoa oa ho kenyelletsa legend chart ea Excel 2010 1348_4](/userfiles/22/1348_4.webp)
Mokhoa oa ho Fetola temana ea litšōmo ho chate e sebetsang 2010
Sappings Of verrand, haeba e lakatsa, e ka fetoloa ka ho beha fonte e loketseng le boholo. O ka etsa ts'ebetso ena ho latela litaelo tse latelang:- Haha setšoantšo ebe u eketsa le tsebiso ho eona ho algorithm e tšohliloeng ka holimo.
- Ema boholo ba boholo, fonte e ngotsoeng ea mohloli oa mohloli oa mohloli oa mohloli oa mohloli oa mohloli oa mohloli oa mohloli oa mohloli oa mohloli oa mohloli oa mohloli oa moo kemiso o hahiloeng ho eona. Ha u theha mongolo ka likholomo tsa tafole, mongolo oo setšoantšong sa chate o tla fetoha hantle.
- Lekola sephetho.
Mokhoa oa ho tlatsa chate
Ntle le nalane, ho na le data e eketsehileng e ka bontšoa kemisong e hahiloeng. Mohlala, lebitso la eona. Ho bolela ntho e hahiloeng, ho bohlokoa ho sebetsa ka tsela e latelang:
- Haha setšoantšo se potileng mohloli o potileng le ho fetela ho "Lageout" ka holim'a lenane la sehlooho.
- Sebaka sa mosebetsi ka lits'oants'o li tla bula, moo liparame tse 'maloa li fumanehang ho fetoha. Boemong bona, mosebelisi o hloka ho tobetsa konopo ea "Setšoantšo sa" Diagram ".
- Lenaneng le aketsehileng la likhetho, khetha mofuta oa mofuta oa sebaka. E ka kenngoa setsing se nang le ho tlola, kapa ka holim'a kemiso.
![Mokhoa oa ho kenyelletsa legend chart ea Excel 2010 1348_5](/userfiles/22/1348_5.webp)
- Kamora ho etsa mashano a fetileng, mongolo oa mongolo "setšoantšo" o hlaha ka graph e hahiloeng. Mosebelisi oa eona o tla khona ho fetoha, ho fana ka lebitso la k'homphieutha e 'ngoe ea mantsoe e kopantsoeng le moelelo oa mohloli oa mohloli oa mohloli.
![Mokhoa oa ho kenyelletsa legend chart ea Excel 2010 1348_6](/userfiles/22/1348_6.webp)
- Ho bohlokoa hape ho saena axis chate. Ba ingolisa ka tsela e tšoanang. Ka har'a mosebetsi oa mosebetsi o nang le lichate, o tla hloka ho tobetsa konopo ea "Axis". Lenaneng le sa bonoeng, khetha e 'ngoe ea li-axes: e ngoe e otlolohileng kapa e otlolohileng kapa e otlolohileng. E latelang, etsa phetoho e loketseng ho khetho e khethiloeng.
![Mokhoa oa ho kenyelletsa legend chart ea Excel 2010 1348_7](/userfiles/22/1348_7.webp)
Mokhoa o mong oa ho fetola chate ea legend e felletseng
U ka hlophisa temana ea li-signature mabapi le lenaneo u sebelisa sesebelisoa se hahiloeng lenaneong. Ho etsa sena, o hloka ho etsa mehato e fokolang ho Algorithm:- Musisulator e nepahetseng tobetsa ho lentsoe le lakatsehang le qabana chate e hahiloeng.
- Boemong bo boholong fensetereng, tlanya ho "Filters". Kamora moo, fensetere ea litlolo tsa setso e buloa.
- Tobetsa ho konopo ea "Khetha data", e ka tlase ho fensetere.
- Metsoako e mecha ea "Khetha mehloli ea data", o tlameha ho tobetsa ho "phetoho" ka "Legend" block.
- Ka fensetere e latelang ea Lethathamo la "Lebitso la" Lebitso ", u tla ngolisa lebitso le fapaneng bakeng sa Elementi e neng e khethiloe ebe o tobetsa" OK ".
- Lekola sephetho.
Sephetho
Kahoo, kaho ea lipale ho Microsoft Office Excel 2010 e arotsoe ka mekhahlelo e 'maloa, e' ngoe le e 'ngoe e hloka thuto e qaqileng. Haeba u lakatsa, tlhaiso-leseling e mocheng e ka hlophiseha kapele. Ka holimo melao ea mantlha ea mosebetsi le lichate tse Excel li hlalositsoe.
Molaetsa Tsela ea ho Sebelisa Leqheka ho chate ea Excel ea 2010 e qalile pele ho theknoloji ea tlhahisoleseling.