Ama-legends ahlala ku-Excel; thola kuphi!
Esikhathini ishadi noma igrafu ezinhlelweni zespredishithi njenge-Microsoft Excel, inganekwane ihlala ikhona ngakwesokudla kweshadi noma igrafu futhi ngezinye izikhathi ingazungezwe umngcele.
I-legend ixhunyaniswe nedatha ekhonjiswa ngokucacile endaweni yendawo yeshadi. Okungenayo ngakunye kwe-legend kuhlanganisa ukhiye we-legend wokubhekisela kudatha.
Qaphela: I-legend nayo yaziwa njengesihluthulelo seshadi.
Yiziphi Izihluthulelo Zomlando?
Ukwengeza ekudidekeni phakathi kwendatshana nokhiye, iMicrosoft ibhekisela kwisici ngasinye ngabanye emlandweni njengekhiye legend.
Isihluthulelo se-legend singumaki owodwa noma obhalwe ngephethini emlandweni. Ngakwesokudla kwekhiye ngayinye legend igama elikhomba idatha emelelwe ukhiye.
Kuye ngohlobo lweshadi, izinkinobho ze-legend zimelela amaqembu ahlukene wedatha ekhasini lokusebenzela elihambisana nalokhu:
- Ukuze uthole igrafu yomugqa , ibrafu yebha, noma ishadi lamakholomu , ukhiye ngamunye we-legend ubhekisela uchungechunge olulodwa lwedatha .
- Isibonelo, eshadini lesikholomu, ungase ube nekhiye legendlo eluhlaza okwesibhakabhaka elifunda Umdala eceleni kwalo, ne-orange eyodwa yegama. Imibala eluhlaza okwesibhakabhaka eshadini ibhekisela eminyakeni yobudala ngayinye kulolu chungechunge lwegama.
- Ishadi lephayi noma igrafu yembuthano, ikhi ngayinye ye-legend imelela kuphela ingxenye yochungechunge olulodwa lwedatha.
- Ukuze usebenzise isibonelo esifanayo kusuka phezulu, kodwa ishadi lephayi, zonke izinsika ze-pie umbala ohlukile omele igama ngalinye "Igama". Njalo ingxenye ye-pie ubukhulu obuhlukile bombuthano wonke ukumelela umehluko weminyaka othathwe ohlwini lwe "Age".
Ukuhlelwa Kwezinganekwane Nezingqikithi Zomlando
Ku-Excel, izinkinobho ze-legend zixhunyaniswa nedatha endaweni yendawo, ngakho ukushintsha umbala wekhi legend kuyophinde ishintshe umbala wedatha endaweni yendawo.
Ungacindezela ngakwesokudla noma uthinte-ubambe kunkinobho legend, bese ukhetha I- Format Legend Entry , ukushintsha umbala, iphethini, noma isithombe esetshenziselwa ukumelela leyo datha.
Ukuze ushintshe izinketho ezihlobene nendaba yonke futhi hhayi nje ukungena okuqondile, chofoza ngakwesokudla noma thinta-futhi ubambe ukuze uthole inketho ye- Format Legend . Yileyo ndlela oyishintsha ngayo umbhalo ogcwalisiwe, umbhalo odwetshwayo, umphumela wombhalo, kanye nebhokisi lombhalo.
Indlela Yokubonisa I-Legend ku-Excel
Ngemuva kokwenza ishadi ku-Excel, kungenzeka ukuthi inganekwane ayibonisi. Ungakwazi ukunika inganekwane ngokuyisusa nje.
Nansi indlela:
- Khetha ishadi.
- Finyelela kuthebhu yokuklama phezulu kwe-Excel.
- Vula imenyu ye- Add Chart Element .
- Khetha i- Legend kusukela kwimenyu.
- Khetha ukuthi inganekwane kufanele ibekwe kuphi - ngakwesokudla, phezulu, kwesobunxele, noma ngezansi.
Uma inketho yokwengeza i-legend ikhonjisiwe, kusho ukuthi kudingeka ukhethe idatha kuqala. Chofoza ngakwesokudla ishadi elisha, elingenalutho bese ukhetha Khetha Idatha , bese ulandela imiyalelo esesikrinini ukuze ukhethe idatha ishadi okufanele limele.