Legends anogara muExcel; tsvakai kupi!
Muchidimbu kana girafu mumapurogiramu epadheseti seMicrosoft Excel, nheyo yacho inowanzowanikwa kuruoko rworudyi rwechati kana grafu uye dzimwe nguva inopoteredzwa nemuganhu.
Nhoroondo yacho inobatanidza ne data iri kuratidzwa zvakajeka munharaunda yenzvimbo ye chati. Chimwe nechimwe chinyorwa munhoroondo yacho chinosanganisira nheyo yechirangaridzo yekutarisa kune data.
Cherechedza: Nhoroondo yacho inozivikanwawo seChiti's Key.
Chii Chinonzi Keiyi Maoko?
Kuti uwedzere kuvhiringidzi pakati pezvakanyorwa uye chinokosha, Microsoft inotaura kune chimwe nechimwe chinhu munhau sechinhu chinonzi legend.
Nheyo yechirangaridzo ndeyeiyo yakavaraidza kana yakagadziriswa muzvenhau. Kune kurudyi kweimwe nhepfenyuro yechiratidzo ndiro zita rinofananidzira deta rinomiririrwa nekiyi.
Zvichienderana nemhando yechati, zvinyorwa zvinopikisa zvinomirira mapoka akasiyana-siyana e data mune pepa rinotevera riri:
- Kana iri girafu yemurongo , bar graph, kana kuti chandori chati , chinhu chimwe nechimwe chinyorwa chinomiririra nyaya imwe chete.
- Semuenzaniso, mune imwe korata chati, iwe unogona kuva nekamuti yepeu yebhuruu iyo inoverenga Age pane imwe, uye rimwe rezai reZita. Mivara yebhuruu iri muchati inoreva nguva yega yega yega kupinda muZita rakanyorwa.
- Nokuda kwechati chepeta kana denderedzwa grafu, nheyo imwe neimwe yechiratidzo inomiririra chikamu cheimwe nyaya dzakasiyana-siyana.
- Kuti ushandise muenzaniso iwoyo kubva kumusoro, asi chetaundi yepayiri, zvese zvakagadzirwa zvepeti ndeye ruvara rwakasiyana runomiririra imwe neimwe ye "Zita". Chikamu chimwe nechimwe chechirasi chikamu chakasiyana chechizunguro chose kuti chimirire nguva yakasiyana yakatorwa kubva ku "Age" series.
Kugadzirisa Legends uye Legend Keys
MuchiExcel, zvinyorwa zveshoko zvakabatanidzwa kune data munharaunda yemunda, saka kuchinja mararamiro echinhu chinonzi legendzo kuchachinjawo mararamiro e data munharaunda yacho.
Unogona kukomba zvakananga kana kubata-uye-kubatisisa pachikwereti chenyaya, uye sarudza Format Legend Entry , kuti uchinje ruvara, muenzaniso, kana chifananidzo chinoshandiswa kureva iyo data.
Kuti uchinje zvisarudzo zvine chokuita nenyaya yose uye kwete kungova imwe chete yekupinda, kurudyi-kanda kana kubata-uye-kubata kuti uwane Format Legend chisarudzo. Iyi ndiyo nzira yaunoshandura nayo magwaro kuzadza, rondedzero, zvinyorwa, uye mabhokisi.
Nzira Yokuratidza Nayo Nhoroondo Sei muExcel
Mushure mokuita chati muExcel, zvingaita kuti nhoroondo yacho isingaratidzi. Iwe unogona kugonesa nhangano kuburikidza nokuchigadzirisa chete.
Heino nzira:
- Sarudza chati.
- Famba muGadzira rakagadzirwa pamusoro pe Excel.
- Vhura mharidzo yeDhaire Element .
- Sarudza Gwaro kubva mumenyu.
- Sarudza kuti nheyo yacho inofanira kuiswa sei - yakarurama, kumusoro, kuruboshwe, kana pasi.
Kana sarudzo yekuwedzera nhepfenyuro yakabviswa, inongoreva kuti unoda kusarudza damba kutanga. Sarudza -bhora chati chitsva, chisina chinhu uye sarudza Sarudza Data , uye tevera mirayiridzo pa-skrini kuti usarudze data iyo chati inofanira kumiririra.