Okuqukethwe
Iseluleki Seshadi Esisha
Inqubo yokwakha amashadi ohlu olukhethiwe lwamaseli manje yenziwe lula kakhulu ngenxa yebhokisi lengxoxo elisha elinokubuka kuqala kweshadi eliqediwe (zombili izinketho ngesikhathi esisodwa - ngemigqa namakholomu):
Amashadi ahlanganisiwe lapho izinhlobo ezimbili noma ezintathu zixutshwe khona (i-histogram-plot-nezindawo, njll.) manje abekwe endaweni ehlukile futhi alungiselelwa kalula ngokushesha efasiteleni le-Wizard:
Futhi manje efasiteleni lokufaka ishadi kukhona ithebhu Amashadi anconyiwe (Amashadi anconyiwe), lapho i-Excel izophakamisa izinhlobo zeshadi ezifanele kakhulu ngokusekelwe ohlotsheni lwedatha yakho yokuqala:
Iphakamisa, kufanele ngisho, ngokufaneleka kakhulu. Ezimweni ezinzima, uphakamisa ngisho nokusebenzisa i-axis yesibili ngesilinganiso sayo (ama-ruble-amaphesenti), njll Akukubi.
Ukwenza ngokwezifiso amashadi
Ukuze ulungiselele ngokushesha zonke izinhlaka eziyisisekelo zanoma yiliphi ishadi, manje ungasebenzisa izinkinobho ezintathu zokhiye ezivela kwesokudla seshadi elikhethiwe:
- Izakhi zeshadi (Izici Zeshadi) - ikuvumela ukuthi wengeze ngokushesha futhi wenze ngendlela oyifisayo noma iyiphi ingxenye yeshadi (izihloko, izimbazo, igridi, amalebula edatha, njll.)
- Izitayela zeshadi (Izitayela Zeshadi) - ivumela umsebenzisi ukuthi akhethe ngokushesha ukwakheka kanye nombala wephalethi yomdwebo eqoqweni
- Izihlungi Zeshadi (Izihlungi Zeshadi) - ikuvumela ukuthi uhlunge idatha yeshadi ngokuhamba kwesikhathi, ushiye kuphela uchungechunge oludingekayo nezigaba ezikulo
Yonke into yethulwa kalula ngendlela yamamenyu asezingeni eliphezulu, isekela ukubuka kuqala lapho undiza futhi isebenza ngokushesha nangokufanele:
Kodwa-ke, uma lesi sikhombikubona esisha sokwenza ngokwezifiso singakuthandi, ungahamba ngendlela yakudala - yonke imisebenzi eyisisekelo yokwenza ngokwezifiso ukubukeka kweshadi ingenziwa kusetshenziswa amathebhu. umakhi (Umklamo) и Framework (Ifomethi). Nawa amathebhu Isakhiwo (Isakhiwo), lapho izinketho eziningi zeshadi zalungiswa ku-Excel 2007/2010, azisekho.
Ifasitelana lomsebenzi esikhundleni samabhokisi ezingxoxo
Ukuhlela kahle umklamo wesici ngasinye seshadi manje sekwenziwa kalula kakhulu kusetshenziswa iphaneli ekhethekile ngakwesokudla kwewindi le-Excel 2013 - ifasitelana lomsebenzi elithatha indawo yamabhokisi ezingxoxo zokufometha akudala. Ukuze ubonise leli phaneli, chofoza kwesokudla kunoma iyiphi ingxenye yeshadi bese ukhetha umyalo Framework (Ifomethi) noma cindezela isinqamuleli sekhibhodi CTRL + 1 noma chofoza kabili kwesokunxele:
Amalebula edatha ye-callout
Uma wengeza amalebula edatha ezintweni ezikhethiwe zochungechunge lweshadi, manje sekungenzeka ukuthi uwahlele ngama-callout aqoshwe ngokuzenzakalelayo kumaphoyinti:
Ngaphambilini, ama-callout anjalo bekufanele adwetshwe ngesandla (okungukuthi, afakwe nje njengezinto ezihlukene zezithombe) futhi, vele, kwakungekho mbuzo wanoma yikuphi ukubophezela kudatha.
Amalebula amaphoyinti asuka kumaseli
Angiwakholwa amehlo ami! Ekugcineni, iphupho labasebenzisi abaningi lifezekile, futhi onjiniyela basebenzise obekulindeleke kubo iminyaka ecishe ibe ngu-10 - manje ungathatha amalebula edatha yezingxenye zochungechunge lwamashadi ngokuqondile eshidini ngokukhetha inketho ku- ifasitelana lomsebenzi Amanani asuka kumaseli (Amanani Asuka Kumaseli) kanye nokucacisa ububanzi bamaseli anamalebula amaphuzu:
Amalebula ebhamuza namashadi ahlakazayo, noma imaphi amalebula angajwayelekile awaseyona inkinga! Okwakungenzeka ngesandla kuphela (zama ukwengeza amalebula kumaphoyinti angamashumi amahlanu ngesandla!) noma usebenzisa ama-macros / izengezo ezikhethekile (i-XYChartLabeler, njll.), manje isiwumsebenzi ojwayelekile we-Excel 2013.
Ishadi Lopopayi
Lesi sici esisha sokushadi ku-Excel 2013, nakuba singesona esikhulu, sisazongeza i-mojo emibikweni yakho. Manje, lapho ushintsha idatha yomthombo (ngesandla noma ngokubala kabusha amafomula), umdwebo "uzogeleza" kahle uye esimweni esisha, ubonisa izinguquko ezenzekile:
Triple, kodwa nice.
- Yini entsha ku-Excel 2013 PivotTables