Ungawazungeza kanjani amashadi ku-Excel

Lesi sihloko sikhuluma ngendlela yokuzungezisa ishadi ku-Excel 2010-2013. Uzofunda izindlela ezahlukahlukene zokuzungezisa ibha, ibha, iphayi namashadi omugqa, okuhlanganisa nezinguqulo zawo ze-3D. Uzobona nokuthi ungashintsha kanjani ukuhleleka kokwakhiwa kwamanani, izigaba, uchungechunge, nenganekwane. Kulabo abavame ukuphrinta amagrafu namashadi, funda ukusetha umumo wephepha ukuze uphrinte.

I-Excel yenza kube lula kakhulu ukwethula ithebula njengeshadi noma igrafu. Ukuze wenze lokhu, vele ukhethe idatha bese uchofoza isithonjana sohlobo olufanele lweshadi. Nokho, izilungiselelo ezizenzakalelayo zingase zingafaneleki. Uma ufuna ukuzungezisa ishadi ku-Excel ukuze uhlele izingcezu zikaphaya, amakholomu, noma imigqa ngokuhlukile, khona-ke lesi sihloko ngesakho.

• Zungezisa ishadi likaphayi ku-Excel libe i-engeli oyifunayo
• Zungezisa Amagrafu e-3D ku-Excel: Zungezisa Uphaya, Amashadi Ebha kanye Nebha
• Zungezisa Ishadi ngo-180°: Hlela kabusha Izigaba, Amanani, Nochungechunge Lwedatha
  
  • Ukushintsha Ukuhleleka Kwezigaba Zokwakha Eshadini le-Excel
  • Ukushintsha I-Order of Building Values
  • Ibuyisela emuva ukuhleleka kochungechunge lwedatha eshadini le-3D
  • Shintsha indawo yenganekwane eshadini
• Ukushintsha umumo weshidi ukuze ufane kangcono neshadi
• Ukusebenzisa Ithuluzi Lekhamera Ukuze Uzungezise Ishadi le-Excel libe I-engeli Engafanele

Zungezisa ishadi likaphayi ku-Excel libe i-engeli oyifunayo

Uma ngokuvamile udinga ukukhombisa osayizi abahlobene ngokulingana, kungcono ukusebenzisa amashadi ophaya. Esithombeni esingezansi, amalebula edatha adlula izihloko, ngakho ishadi libukeka lingcolile. Ngifuna ukukopisha leli shadi ngenze isethulo se-PowerPoint mayelana namasiko okupheka ezizwe, futhi ngidinga ishadi ukuthi licoceke. Ukuze wenze umsebenzi wenziwe futhi ugqamise umkhakha obaluleke kakhulu, udinga ukwazi ukuthi uzungezisa kanjani ishadi likaphayi ku-Excel ngokwewashi.

1. Chofoza kwesokudla kunoma iyiphi ingxenye yeshadi lakho likaphayi nakumenyu evelayo, khetha Ifomethi yochungechunge lwedatha (Uchungechunge Lwedatha Yefomethi).
2. Iphaneli yegama elifanayo izovela. Ensimini I-engeli yokuzungezisa yomkhakha wokuqala (I-engeli yocezu lokuqala), esikhundleni sikaziro, faka inani le-engeli yokuzungezisa ngamadigri bese ucindezela Faka. Ngicabanga ukuthi ukuzungezisa okungu-190 kuzokwenzela ishadi lami likaphayi.

Ngemuva kokuzungezisa, ishadi likaphayi ku-Excel libukeka licocekile impela:

Ngakho-ke, akunzima ukuzungezisa ishadi le-Excel kunoma iyiphi i-engeli ukuze ulinikeze ukubukeka okufunayo. Le ndlela iwusizo kokubili ekulungiseni kahle indawo yamalebula edatha kanye nokugqamisa imikhakha ebaluleke kakhulu.

Zungezisa Amagrafu e-3D ku-Excel: Zungezisa Uphaya, Amashadi Ebha kanye Nebha

Ngicabanga ukuthi amashadi e-3D abukeka emuhle kakhulu. Lapho abanye abantu bebona igrafu engu-XNUMXD, banesiqiniseko sokuthi umdali wayo wazi konke mayelana nezindlela zokubuka ku-Excel. Uma igrafu edalwe ngezilungiselelo ezizenzakalelayo ingabukeki ngendlela obungathanda ngayo, ungayilungisa ngokuzungezisa futhi uguqule izilungiselelo zokubuka.

1. Chofoza kwesokudla eshadini bese ukhetha kumenyu evelayo. Ukujikeleza kwe-XNUMXD (Ukuzungezisa okungu-3-D).
2. Iphaneli izovela Ifomethi Yendawo Yeshadi (Indawo Yeshadi Lefomethi). Emasimini Zungezisa i-X eksisi (X Rotation) kanye Ukuzungezisa i-eksisi ka-Y (Y Ukuzungezisa) Faka inombolo oyifunayo yamadigri ukuze uzungezise.Ngibeka amanani ku-40 ° no-35 ° ngokulandelanayo ukuze nginikeze isiqephu sami ukujula okuthile.

Ungakwazi futhi ukusetha izinketho kuleli phaneli. Ukujula (Ukujula), Ukuphakama (Ukuphakama) kanye Perspective (Umbono). Linga ukuze uthole izilungiselelo ezingcono kakhulu zeshadi lakho. Ngendlela efanayo, ungasetha ishadi likaphayi.

Zungezisa Ishadi ngo-180°: Hlela kabusha Izigaba, Amanani, noma Uchungechunge Lwedatha

Uma ishadi ofuna ukulizungezisa ku-Excel libonisa zombili izimbazo ezivundlile nezime mpo, ungakwazi ukushintsha kalula ukuhleleka kwezigaba noma amanani aklanywe kulawo mazembe. Ngaphezu kwalokho, eziqephuni ze-3D ezine-eksisi ejulile, ungashintsha indlela uchungechunge lwedatha oluhlelwa ngayo ukuze amabha amakhulu e-3D angadluleli amancane. Ku-Excel, ungakwazi futhi ukushintsha indawo yenganekwane eshadini likaphayi noma ishadi lebha.

Shintsha ukuhleleka kwezigaba zokwakha emdwebeni

Ishadi lingazungeziswa mayelana ne-eksisi evundlile (i-eksisi yesigaba).

1. Chofoza kwesokudla ku-eksisi evundlile nakumenyu evelayo khetha Ifomethi ye-eksisi (Fometha i-eksisi).
2. Iphaneli yegama elifanayo izovela. Ukuze uphendukise ishadi ngo-180°, mane uhlole ibhokisi Ukuhlehlisa ukuhleleka kwezigaba (Izigaba ngokulandelana okuphambene).

Shintsha uhlelo lokuhlela amanani eshadini

Ngokulandela lezi zinyathelo ezilula, ungakwazi ukuphenya ishadi ku-eksisi eqondile.

1. Chofoza kwesokudla ku-eksisi eqondile (i-axis yenani) bese ukhetha Ifomethi ye-eksisi (Fometha i-eksisi).
2. Bheka ibhokisi Hlehlisa ukuhleleka kwamanani (Amanani alandelana ngokuhlehla).

Qaphela: Khumbula ukuthi akwenzeki ukuguqula indlela amanani ahlelwe ngayo eshadini le-radar.

Ibuyisela emuva ukuhleleka kochungechunge lwedatha eshadini le-3D

Uma ibha yakho noma ishadi lebha line-eksisi yesithathu, enamabha ngaphambili futhi amanye ngemuva, ungashintsha indlela uchungechunge lwedatha ehlelwa ngalo ukuze izici ezinkulu ze-3D zingadluleli ezincane. Kusetshenziswa izinyathelo ezilandelayo, iziqephu ezimbili noma ngaphezulu zingakhiwa ukuze kuboniswe lonke uchungechunge lwenganekwane.

1. Chofoza kwesokudla ku-axis yochungechunge lwenani (i-axis Z) eshadini nakumenyu evelayo, chofoza Ifomethi ye-eksisi (Fometha i-eksisi).
2. Bheka ibhokisi Hlehlisa ukuhleleka kwamanani (Uchungechunge ngokulandelana) ukuze kuboniswe amakholomu ngokulandelana okuphambene.

Shintsha indawo yenganekwane eshadini

Eshadini likaphayi le-Excel elingezansi, inganekwane ingezansi. Ngifuna ukuhambisa inganekwane ngakwesokudla seshadi ukuze idonse ukunaka kangcono.

1. Chofoza kwesokudla ku-legend nakumenyu evelayo, chofoza Ifomethi yeLegend (Ilejendi Yefomethi).
2. Esigabeni Izinketho zelejendi (Izinketho ze-legend) khetha ibhokisi likaqhwishi elilodwa: Kusukela phezulu (Phezulu), Bottom (Phansi), Kwesokunxele (Kwesobunxele), Kwesokudla (kwesokudla) noma Top kwesokudla (Phezulu kwesokudla).

Manje ngithanda umdwebo wami kakhulu.

Ukushintsha umumo weshidi ukuze ufane kangcono neshadi

Uma udinga nje ukuphrinta ishadi, vele uguqule umumo weshidi ku-Excel ngaphandle kokuzungezisa ishadi ngokwalo. Isithombe esingezansi sibonisa ukuthi ishadi alilingani ngokuphelele ekhasini. Ngokuzenzakalela, amashidi okusebenzela aphrinta ngomumo wokuma ngobude (ophakeme kunobubanzi). Ukuze isithombe sami sibukeke kahle uma siphrintwa, ngizoshintsha umumo wekhasi usuke ekumatheni kuye ku-landscape.

1. Khetha ishidi lokusebenzela elineshadi ozoliphrinta.
2. Chofoza Isakhiwo sekhasi (Isakhiwo Sekhasi), chofoza umcibisholo ongaphansi kwenkinobho UkuJayela (Ukuma) bese ukhetha inketho Emazweni (Indawo).

Manje efasiteleni lokubuka kuqala, ngiyabona ukuthi ishadi lingena kahle endaweni ephrintekayo.

Ukusebenzisa Ithuluzi Lekhamera Ukuze Uzungezise Ishadi le-Excel libe I-engeli Engafanele

Ku-Excel, ungazungezisa ishadi libe kunoma iyiphi i-engeli usebenzisa ithuluzi Ikhamera. Umphumela womsebenzi Amakhamera ingafakwa eduze kwegrafu yokuqala noma eshidini elisha.

Ithiphu: Uma udinga ukuzungezisa ishadi ngo-90°, kwezinye izimo kwanele ukumane uguqule uhlobo lweshadi. Isibonelo, ukusuka kubha yeshadi ukuya eshadini lebha.

Ukwengeza ithuluzi Ikhamera Kubha yamathuluzi yokufinyelela Ngokushesha, sebenzisa okuncane phansi umcibisholo ngakwesokudla kwephaneli. Kumenyu evelayo, chofoza Amanye amaqembu (Eminye Imiyalo).

Khetha Ikhamera (Ikhamera) ohlwini Wonke amaqembu (Yonke imiyalo) bese ucindezela Engeza (Engeza).

Manje ukusebenzisa ithuluzi Ikhamera, landela lezi zinyathelo ezingezansi.

Qaphela: Sicela ukhumbule ukuthi akunakwenzeka ukusebenzisa ithuluzi Ikhamera ngqo eshadini, njengoba umphumela ungase ube ongalindelekile.

1. Dala igrafu nanoma yiliphi elinye ishadi.
2. Kungase kudingeke ukuzungezisa ukuma kwamalebula ezimbazo zeshadi ngo-270° usebenzisa imenyu Ifomethi ye-eksisi (I-Format Axis), echazwe ngenhla. Lokhu kuyadingeka ukuze amalebula akwazi ukufundwa ngemva kokuba ishadi lizungeziswe.
3. Khetha ububanzi bamaseli ishadi elingenhla.
4. Chofoza isithonjana Ikhamera (Ikhamera) kubha yamathuluzi yokufinyelela Ngokushesha.
5. Chofoza kunoma iyiphi iseli yeshidi ukuze udale into yekhamera.
6. Manje chofoza bese ubamba isibambo sokuzungezisa phezulu komdwebo owumphumela.
7. Zungezisa ishadi libe yi-engeli oyifunayo bese ukhulula isibambo sokuzungezisa.

Qaphela: Ensimbini Ikhamera kune-drawback eyodwa. Izinto eziwumphumela zingase zibe nokulungiswa okuphansi kuneshadi langempela, futhi zingase zibonakale ziluhlaza noma zimangelengele.

Ukushaja kuyindlela enhle yokubonisa idatha. Amagrafu ku-Excel kulula ukuwasebenzisa, acacile, abonwayo, futhi umklamo ungenziwa ngendlela oyifisayo ukuze uvumelane nanoma yisiphi isidingo. Manje usuyazi ukuthi ungazungezisa kanjani ama-histograms, umugqa namashadi ophayi.

Ngemva kokubhala konke lokhu, ngizizwa ngiyi-guru yangempela emkhakheni wokujikeleza kweshadi. Ngithemba ukuthi isihloko sami sizokusiza ukwazi ukubhekana nomsebenzi wakho. Jabula futhi uthuthukise ulwazi lwakho lwe-Excel!