Imithetho ihlala kwi-Excel; fumana apho!
Kwitshathi okanye igrafu kwiiprogram zepredishithi ezifana ne-Microsoft Excel, igosa lihlala likhona kwicala lasekunene lesitshati okanye igrafu kwaye ngamanye amaxesha lingadibana nomda.
Umgca unxulumene nedatha ebonakaliswa ngokucacileyo kwingingqi yesalathisi yetshathi. Ukungena ngokuthe ngqo kwimbali kufaka iqhosha lomgca lokubhekisela kwiedatha.
Qaphela: Umgca uyaziwa ngokuba yiKhadi leKhadi.
Ziziphi Iimpawu zeLigama?
Ukongeza kwidideko phakathi kwendatshana kunye nencoko, iMicrosoft ibhekisela kwisici ngasinye kwisigangqa njengesicatshulwa.
Iqhosha lomgca lombala omnye okanye umzekelo wesigcawu kwimbali. Ukunene kwesicatshulwa ngasinye somxholo igama elichazela idatha emele ibalulekileyo.
Ngokuxhomekeke kwindlela yetshathi, iimpawu zengqungquthela zimela amaqela ahlukeneyo edatha kwiphepha lokusebenzela elilandelayo:
- Kuluhlu lwegrafu , ibrafu, okanye ididi yekholomu , iqhosha lomgca ngalinye limela uchungechunge olulodwa lweedatha .
- Ngokomzekelo, kwitshathi yekholomu, unokuba nencoko yelungu elihlaza okwesibhakabhaka elifunda Umda ngaphantsi kwalo, kunye nelinye leLandune legama. Imibala eluhlaza okwesibhakabhaka ibhekisela kwixesha lokungena ngalinye kwi-series Name.
- Kwidatha yeepeyi okanye isangqa lesigcawu, ikona nganye yecala imele kuphela inxalenye yechungechunge lwedatha enye.
- Ukusebenzisa umzekelo ofanayo ovela phezulu, kodwa isatidi yeepeyi, yonke isinqunyiweyo se-pie ngumbala ohlukileyo omele igama ngalinye elithi "Igama". Yonke isahlulo se-pie yayizibukhulu obuhlukileyo kwisangqa sonke ukumela ukungalingani kweminyaka ethathwe kwi-"Age".
Imithetho yokuLungiselela kunye neNqakraza yeeNgcaciso
Ku-Excel, izitshixo zomgca zixhunyaniswa nedatha kwindawo yendawo, ngoko ukutshintsha umbala weqhosha lomgca kuya kutshintsha umbala wedatha kwindawo yendawo.
Unokunqakraza ngokuchanekileyo okanye uthayiphe-kwaye ubambe iqhosha lomgca, kwaye ukhethe Ifayile Yokungena Kwefomathi , ukutshintsha umbala, iphethini, okanye umfanekiso osetyenziswa ukumela loo datha.
Ukutshintsha izinto ezinxulumene nalo lonke iqhosha kwaye kungekhona nje ukungena okuthe ngqo, nqakraza ngakwesokudla okanye thintela kunye nokubamba ukufumana ifayile yefomathi yefomathi. Yileyo ndlela uguqula isicatshulwa sokugcwalisa, isicatshulwa sombhalo, umxholo wesicatshulwa, kunye nebhokisi yombhalo.
Indlela Yokubonisa I-Legend kwi-Excel
Emva kokwenza ishati kwi-Excel, kungenzeka ukuba umgca awubonakali. Unokwenza umgca ngokumane uguqula.
Nantsi indlela:
- Khetha ishati.
- Finyelela kwiThebhu yoyilo phezulu kwi-Excel.
- Vula imenyu ye- Chart Element menu.
- Khetha Impendulo kwimenyu.
- Khetha apho umgca kufuneka ubeke khona-kunene, phezulu, ngakwesobunxele, okanye ngaphantsi.
Ukuba ukhetho lokwengeza umgca lugqityiweyo, lithetha nje ukuba kufuneka ukhethe idatha kuqala. Chofoza iqhosha elitsha, elingenalutho uze ukhethe Khetha iData , uze ulandele imiyalelo esesikrinini ukuze ukhethe idatha emele ifane.