Mangaza ozakwethu ngeshadi lobuso bewashi ku-Excel

Uma ufuna indlela yesimanje yokubona idatha ngeso lengqondo, bheka ishadi lobuso bewashi le-Excel. Ishadi lokudayela liklanyelwe ukuhlobisa ideshibhodi, futhi ngenxa yokufana kwalo ne-speedometer yemoto, libizwa nangokuthi ishadi le-speedometer.

Ishadi lobuso bewashi lihle kakhulu ekuboniseni amaleveli okusebenza neziqophamlando.

Igxathu emvakwe gxathu:

  1. Dala ikholomu kuthebula Dayela (okusho ukudayela) futhi kuseli yayo yokuqala sifaka inani elingu-180. Bese sifaka ububanzi bedatha ebonisa ukusebenza kahle, siqala ngamavelu aphikisayo. Lawa manani kufanele abe ingxenyenamba ka-180. Uma idatha yoqobo ivezwa njengephesenti, lapho-ke ingaguqulelwa kumanani aphelele ngokuphindaphinda ngo-180 futhi ihlukanise ngo-100.
  2. Gqamisa ikholomu Dayela bese udala ishadi lamadonadi. Ukuze wenze lokhu, kuthebhu Faka (Faka) esigabeni Imidwebo (Amashadi) chofoza umcibisholo omncane ekhoneni elingezansi kwesokudla (okuboniswe esithombeni esingezansi).Mangaza ozakwethu ngeshadi lobuso bewashi ku-Excel
  3. Ibhokisi lengxoxo lizovuleka Faka ishadi (Faka ishadi). Vula ithebhu Yonke imidwebo (Wonke Amashadi) nakumenyu engakwesokunxele, chofoza Isiyingi (Uphaya). Khetha kuma-subtypes aphakanyisiwe ring (I-Donut) ishadi bese uchofoza OK.Mangaza ozakwethu ngeshadi lobuso bewashi ku-Excel
  4. Ishadi lizovela eshidini. Ukuze ibukeke njengokudayela kwangempela, uzodinga ukushintsha kancane ukubukeka kwayo.Mangaza ozakwethu ngeshadi lobuso bewashi ku-Excel
  5. Khetha iphoyinti 2 ochungechungeni lwedatha Dayela. Kuphaneli Ifomethi yephoyinti ledatha (Fometha Iphoyinti Ledatha) shintsha ipharamitha I-engeli yokuzungezisa yomkhakha wokuqala (I-Angle of First Slice) на 90 °.Mangaza ozakwethu ngeshadi lobuso bewashi ku-Excel
  6. Khetha iphoyinti 1 nasephaneli Ifomethi yephoyinti ledatha (Iphoyinti Ledatha Yefomethi) shintsha ukugcwalisa kube Akukho ukugcwaliswa (Akukho Gcwalisa).Mangaza ozakwethu ngeshadi lobuso bewashi ku-Excel

Ishadi manje selibukeka njengeshadi lokudayela. Kusele ukwengeza umcibisholo ekudayileni!

Ukuze wengeze umcibisholo, udinga elinye ishadi:

  1. Faka ikholomu bese ufaka inani 2. Emugqeni olandelayo, faka inani 358 (360-2). Ukuze wenze umcibisholo ube banzi, khulisa inani lokuqala bese wehlisa elesibili.
  2. Khetha ikholomu bese udala ishadi likaphayi kulo ngendlela efanayo njengoba kuchazwe ngaphambili kulesi sihloko (izinyathelo 2 no-3) ngokukhetha Isiyingi ishadi esikhundleni salokho Iminyaka yonke.
  3. Kumaphaneli Ifomethi yochungechunge lwedatha (Uchungechunge Lwedatha Yefomethi) shintsha ukugcwaliswa komkhakha omkhulu weshadi kube Akukho ukugcwaliswa (Akukho Gcwalisa) bese umngcele uvuliwe akukho mngcele (Awukho Umngcele).
  4. Khetha ingxenye encane yeshadi ezosebenza njengomcibisholo futhi iguqule umngcele ube akukho mngcele (Awukho Umngcele). Uma ufuna ukushintsha umbala womcibisholo, khetha inketho ukugcwalisa okuqinile (Gcwalisa Okuqinile) nombala ofanele.
  5. Chofoza ingemuva lendawo yeshadi nakuphaneli evelayo, shintsha ukugcwalisa kube Akukho ukugcwaliswa (Akukho Gcwalisa).
  6. Chofoza isithonjana sophawu more (+) ukuze uthole ukufinyelela okusheshayo kwemenyu Izakhi zeshadi (Izinto Zeshadi) bese ususe ukumaka amabhokisi aseduze Legend (Inganekwane) kanye Igama (Isihloko Seshadi).Mangaza ozakwethu ngeshadi lobuso bewashi ku-Excel
  7. Okulandelayo, beka isandla ngaphezu kokudayela bese usizungezisa siye endaweni oyifunayo usebenzisa ipharamitha I-engeli yokuzungezisa yomkhakha wokuqala (I-Angle of First Slice).Mangaza ozakwethu ngeshadi lobuso bewashi ku-Excel

Ilungile! Sisanda kwenza ishadi lobuso bewashi!

shiya impendulo