Zamkatimu
Wizard Watsopano Watsopano
Njira yopangira ma chart amagulu angapo osankhidwa tsopano yakhala yosavuta chifukwa cha bokosi latsopano la zokambirana lomwe lili ndi chithunzithunzi cha tchati chomalizidwa (njira zonse ziwiri nthawi imodzi - ndi mizere ndi mizati):
Ma chart ophatikizika pomwe mitundu iwiri kapena itatu yasakanizidwa (histogram-chiwembu-ndi madera, ndi zina zotero) tsopano yayikidwa pamalo osiyana ndipo amakonzedwa mosavuta nthawi yomweyo pawindo la Wizard:
Komanso tsopano pawindo loyika tchati pali tabu Ma chart ovomerezeka (Matchati ovomerezeka), pomwe Excel idzawonetsa mitundu yoyenera kwambiri ya tchati kutengera mtundu wa data yanu yoyamba:
Amapereka, ndiyenera kunena, mwaluso kwambiri. Pazovuta, akuwonetsanso kugwiritsa ntchito nsonga yachiwiri ndi sikelo yake (rubles-peresenti), etc. Osati zoipa.
Kusintha ma chart
Kuti mukonze mwachangu magawo onse a tchati chilichonse, mutha kugwiritsa ntchito mabatani atatu ofunikira omwe amawonekera kumanja kwa tchati chomwe mwasankha:
- Ma chart a zinthu (Zinthu Zachati) - imakupatsani mwayi wowonjezera ndikusintha makonda aliwonse (mitu, nkhwangwa, gululi, zilembo za data, ndi zina)
- Masitayilo a ma chart (Masitayelo a ma chart) - amalola wogwiritsa ntchito kusankha mwachangu mapangidwe ndi utoto wamtundu wa chithunzicho kuchokera pazosonkhanitsira
- Zosefera Ma chart (Zosefera ma chart) - imakupatsani mwayi kuti musefa deta ya tchati pa ntchentche, ndikusiya mndandanda wofunikira ndi magulu omwe ali mmenemo
Chilichonse chimawonetsedwa mosavuta m'mamenyu otsogola amitundu ingapo, chimathandizira kuwoneratu ndikuwuluka ndipo chimagwira ntchito mwachangu komanso mosavuta:
Ngati, komabe, mawonekedwe atsopanowa sakukondani, ndiye kuti mutha kupita mwanjira yapamwamba - ntchito zonse zoyambira pakukonza mawonekedwe a tchati zitha kuchitidwanso pogwiritsa ntchito ma tabo. Constructor (Kapangidwe) и Makhalidwe (Mtundu). Ndipo apa pali ma tabo Kuyika (Mawonekedwe), pomwe zosankha zambiri za tchati zidasinthidwa mu Excel 2007/2010, palibenso.
Task pane m'malo mwa dialog box
Kukonza bwino kamangidwe ka chinthu chilichonse cha tchati tsopano kwachitika mosavuta pogwiritsa ntchito gulu lapadera kumanja kwa zenera la Excel 2013 - gawo la ntchito lomwe limalowa m'malo mwa mabokosi a masanjidwe akale. Kuti muwonetse gululi, dinani kumanja pa chinthu chilichonse chatchati ndikusankha lamulo Makhalidwe (Mtundu) kapena dinani njira yachidule ya kiyibodi CTRL + 1 kapena dinani kawiri ndi kumanzere:
Zolemba za data ya Callout
Powonjezera zilembo za data kuzinthu zosankhidwa za mndandanda wamatchati, ndizotheka kuwakonza m'ma callout omwe amangoduliridwa ku mfundo:
M'mbuyomu, ma callouts oterowo amayenera kujambulidwa pamanja (ndiko kuti, kungoyika ngati zinthu zosiyana siyana) ndipo, ndithudi, panalibe funso lililonse lomanga deta.
Zolemba za nsonga zamaselo
Sindikukhulupirira zomwe ndikuwona! Pomaliza, maloto a ogwiritsa ntchito ambiri akwaniritsidwa, ndipo opanga akwaniritsa zomwe zakhala zikuyembekezeredwa kwa zaka pafupifupi 10 - tsopano mutha kutenga zolemba za data zamagulu angapo a ma chart mwachindunji kuchokera papepala posankha njirayo. gulu la ntchito Makhalidwe ochokera ku ma cell (Makhalidwe Ochokera ku Maselo) ndi kutchula ma cell angapo okhala ndi ma point:
Zolemba za kuwira ndi kuwaza ma chart, zilembo zilizonse zomwe sizikhala zokhazikika sizikhalanso vuto! Zomwe zinkatheka pamanja zokha (yesani kuwonjezera zilembo ku mfundo makumi asanu ndi dzanja!)
Makanema a Tchati
Chojambula chatsopanochi mu Excel 2013, ngakhale sichili chachikulu, chidzawonjezera mojo kumalipoti anu. Tsopano, posintha magwero (pamanja kapena powerengeranso mafomu), chithunzicho "chimayenda" bwino m'malo atsopano, ndikuwonetsa zosintha zomwe zachitika:
Zochepa, koma zabwino.
- Zatsopano mu Excel 2013 PivotTables