Awazi kanjani ukwakha ishadi Excel

Uma ubhekene umbuzo "Bangaki ukwakha ishadi Excel?», Khona-ke lesi sihloko Yilokho okudingayo.

Ukuze isakhiwo yamashadi ku-Excel, kanye ukwakhiwa zonke izinhlobo amashadi (isib, histograms), lihlangabezana Iseluleki Ishadi.

Masiqale.

1. Vula idokhumenti MS Office Excel. Qala - Zonke Izinhlelo - Microsoft Office - Microsoft Office Excel.

2. Qalisa Master ukwakhiwa zonke amagrafu. On the yamathuluzi phezulu, ukhethe "Faka" ke - Umdwebo.

3. Ishadi Iseluleki iyasebenza. Ukuze kuphelelise umsebenzi wako ngezinyathelo ezine kumele kwenziwe:

1) Khetha uhlobo umdwebo esizayo. Ukwakha atholakalayo nane izinhlobo ichopho, histogram, cylindrical, yakhipha lesi sinqumo, bubble, igrafu, isiyingi, oluneziqhingi, ne izindawo, annular, ebusweni exchange, oyindilinga, pyramidal. Ngakwelinye ihlangothi, kukhethwa uhlobo kwathatha ithebhu "Ngokwezifiso" ungakhetha angajwayelekile izinhlobo yamashadi. Okuningi ...

2) Ukukhethwa senhlobo idatha. Uma kuthuthukiswe, okusho ngaphambi egijima wizadi ukhetha uhla wazifunela imidvwebo esizayo, emkhakheni ke uyogcwala ngokuzenzakalela, kungenjalo - vele ukhethe uhla idatha esiteji wizadi charting yesibili. Esikhathini ithebhu "inombolo" inikezwe ithuba lokubuza amagama izimbazo noma ishadi esinelebuli amagugu.

3) Ukukhetha nemingcele ishadi. Akusona kumele, kodwa kuyatuseka ukuba ugcwalise ngokuphelele. Ngaphandle kwayo, ishadi izokwakhiwa, kodwa uma usaqhubeka ngizibuza indlela ukwakha ishadi Excel kahle, kubalulekile ukuba uligcwalise ukuze esiphezulu. Tab "Headlines" inikeza ithuba igama ishadi esizayo nangezimbazo yayo. Ithebhu ye "-eksisi" kuyadingeka ukuze ukhethe uhlobo amalebula e-eksisi. Bheka "Lines Igridi" ikuvumela ukuba sibonise noma ukubonisa igrafu eziyisisekelo futhi Lesisemkhatsini ukwakhiwa umugqa. I "Legend. Kukhethwa indawo legend (amagugu ukucaciseleka). Idatha Amathebula" ikuvumela ukuba sibonise idatha, okwakubekelwa abekwa ngqo ukwakhiwa yayo. Ithebhu "Idatha Amalebula" ikuvumela ukuthi ungene ngamunye marker ingcaca nokukhetha isihlukanisi elula phakathi amagugu.

4) Ukukhethwa indawo idayagramu. Ngokwesibonelo, uma unentshisekelo indlela yokwakha histogram Excel ekhasini elehlukile, bese ukhetha "Special" futhi ucacise igama ikhasi elisha. Uqedile!

Lezi zinyathelo ezine kukhona elula ukuphendula kungewona umbuzo kunzima kangaka ukuthi ukwakha ishadi Excel.

Manje ake ukubhekana umbuzo ukuhlela noma ukufometha kwaphumela.

Nasi idayagramu. Ake sithi udinga kancane kakhulu ukushintsha ukubukeka kwakhe. Kanjani ukwakha ishadi Excel ne-legends-ithalikhi?

Impendulo: ambalwa izikhathi, chofoza inkinobho yesinxele ku ngemuva kokwakhiwa imidvwebo. Ngu lesi senzo wena biza iwindi "Ifomethi Ishadi Wall", lapho ungakwazi nje ukushintsha ifonti esetshenziswa emkhakheni wokwakha, kodwa futhi ukuzikhethela nesimo sayo ngomugqa adjustable uhlobo, umbala kanye ukushuba, bese wengeza ukusebenza Ithunzi lokwehla ukuze uzimele.

Kabili ngokuchofoza igundane kushadi uqobo, ukuvula iwindi "Ifomethi Sakhiwo Area", lapho ncamashi Futhi ungashintsha ukubukeka uzimele.

Chofoza kabili imigqa yegridi kuzodala "ilebula lokumaka ngethikhi Ifomethi". Lapha ushintsho kungaba isihloko lemigqa (uhlobo, umbala, ukujiya), kanye esikalini. On the "Isilinganisi" lingasethwa ngezigaba, intengo division Lesisemkhatsini, amagugu minimum futhi esiphezulu, kanye neminye imingcele.

Uma umbuzo wakho ngokuqondile, isibonelo, "kanjani ukufeza charting Excel 2010", impendulo kuyoba sihluke lesi sihloko, kuphela iqiniso lokuthi MS Office Excel Ishadi Iseluleki ibizwa ngokuthi inkinobho ehlukene kwi indawo yamathuluzi ejwayelekile. Zonke ezinye izenzo oyokwenziwa ngokuvumelana algorithm ngenhla.

Ishadi - it is hhayi njalo nzima ukwakhiwa. Bheka-Excel futhi uzibonele. Ngikufisela inhlahla!