Ishadi lomugqa futhi Radar: izimiso eziyisisekelo

Kulesi sihloko sizohlola ezinye ezichumayo amashadi: Ishadi lomugqa futhi Radar. Okokuqala, ake sixoxe ukuqokwa zalezi zilwane.

umugqa idayagramu

Yakhelwe ukuqapha izinguquko inombolo yamanani ushintsho kusukela ukuqala eya endaweni yeshadi. Lolu hlobo ingcaca elisetshenziselwa ukuchaza ubudlelwane, ukwahluka Dynamics. Izimpawu geometry kulokhu abaphukile umugqa ehlanganisa amachashazi kanye umugqa izingxenye.

Elichaza Dynamics idayagramu komugqa isicelo ezimweni ezifana:

• Uma isibalo uchungechunge othakazelisayo amazinga likhulu kakhulu. imidvwebo Isicelo kubhekwe kulesi simo ukugcizelela ngokuqhubeka ukuthuthukiswa.

• Ibonisa mkhuba inani nohlobo ukuthuthukiswa inqubo noma mkhuba.

• Ukuqhathanisa ethile isikhathi chungechunge.

• Ukuhlanganiswa nokuthathe kwenza izinga lokhula.

Izici yokwakha: ekulungiseleleni komugqa imidvwebo le abscissa, ngokuvamile isikhathi, kanye ahlelembise - lomchazi. On okufanayo ishadi uhlobo kubhekwe kungenzeka ukwakha Curves eziningana ukuthi zikanhlangothiningi, ukuvumela ukuqhathanisa izinguquko ezihlukahlukene Isikhulumi isikhathi esifanayo.

Radar

Njengoba iklanyelwe i-ukumelwa ngokuqhathanisa amagugu eziningi uchungechunge eyohlobo.

Izici ukwakhiwa yayo: igrafu has a-eksisi ehlukile isigaba ekhethiwe ngamunye amanani. Bonke ngothi lwabo, yena, waba nesiqalo ezivamile. I ukwakha okuholela, ngokuvamile ipholigoni lwalugobile etholwe, elusa isikokela, okuyinto kugrafu is luzuzwe amagugu alinganayo kubhekwe nemingcele. Lokhu igrafu kuboniswa ekhoneni / polar Ukudidiyela uhlelo, ogxile ushintsho yamanani kubhekwe ukuthambekela eksisi. umugqa ngamunye vector, Ngakho-ke, lolu hlobo imidvwebo - esesimweni esihle ukuqhathanisa Amathrendi ezithile.

Wonke amashadi indlela elula ukwakha isihleli se-spreadsheet-Microsoft Office Excel. Ukuze wenze lokhu, kukhona "Ishadi Iseluleki Excel».

Step by step imiyalelo for the "Ochwepheshe charting"

1. Ivula idokhumenti Excel. Qala - Zonke Izinhlelo - Microsoft Office - Microsoft Office Excel.

2. Kumiswa idatha ukwakha in ifomu tabular.

3. Ukuvulwa kwe-"Ochwepheshe PD": Faka - Ishadi / Igrafu.

4. Ukukhetha uhlobo ishadi: umdwebo komugqa (wabusa) noma ichopho.

5. Ukukhethwa umthombo idatha ye ukwakhiwa. Qamba kabusha / igama isabelo imigqa.

6. Ukubeka imingcele yesimiso esizayo. Igama-eksisi ngamunye, igama lonke idayagramu. Khetha ama-eksisi yomkhakha. Veza / fihla eziyisisekelo imigqa / Lesisemkhatsini eshadini. Ukufihla / Ukubonisa ezinganekwaneni, lapho legend kuyinto tabular ifomu imigqa isignesha. Nika amandla / fihla imigqa nezigaba amasignisha amagama kanye namanani (ngoba ezinye izinhlobo amagrafu - ingxenyenamba futhi ubukhulu bubble). Ukufihla / Ukubonisa idatha ifomu tabular ekwakheni umdwebo uqobo.

7. Ukukhetha indawo umphumela wokugcina (operation noma ikhasi elisha yencwadi).

Kulesi umsebenzi "Ochwepheshe charting Excel» angabhekwa ephelele. Yonke inqubo iwukuba ukusetshenziswa kwalezi imiyalelo (ngaphandle kwedatha yokufaka) indlela efanele kuthatha akukho kuka imizuzu eyishumi nanhlanu. Zama it, akunzima kangako!