Indlela yokudala iGraph Line kwi-Excel 2010

Iigrafu zamagama zihlala zisetyenziselwa ukutshintsha utshintsho kwidatha ngokuhamba kwexesha, njengokutshintsha kwelanga lokushisa okanye ukutshintshwa kwansuku zonke kwixabiso lemarike yamasheya. Zingasetyenziselwa ukucwangcisa idatha erekhodwa kwizilingo zesayensi, njengokuthi imichiza iyakwenza njani ukutshintsha kweqondo lokushisa okanye uxinzelelo lwangaphakathi.

Ngokufanayo nezinye iigrafu, imagrafu yomgca ine-axis ecacileyo kunye ne-axis ene-horizontal axis. Ukuba uceba ukwenza utshintsho kwidatha ngokuhamba kwesikhathi, ixesha lihlelwe ngaphaya kwe-axis okanye x-axis kunye nedatha yakho enye, njengemali yokunyuka kwemvula ihlelwe njengamaphuzu ngamanqaku angama-vertical okanye y-axis.

Xa iinkcukacha zedatha zixhunyiwe ngemigca, zibonisa ngokucacileyo utshintsho kwidatha yakho - njengokuba indlela yekhemikhali iguquka ngayo ngokutshintsha kwengcinezelo yemozulu. Ungasebenzisa olu tshintsho ukuze ufumane iindwendwe kwi-dada yakho kwaye mhlawumbi uqikelele iziphumo ezizayo. Ukulandela amanyathelo kule khokelo kukuhamba ngokudala nokufomatha igrafu yomgca ebonwe kumfanekiso ongentla.

Ukwahluka kweenguqulelo

Amanyathelo kule khokelo asebenzisa iindlela zokufomathiza kunye neendlela zokwenza izinto ezifumaneka kwi-Excel 2010 no-2007. Ezi zihluke kwizinto ezifunyenwe kwezinye iinguqu zenkqubo, njenge- Excel 2013 , i- Excel 2003 kunye neenguqulelo zangaphambili.

01 ngo-06

Ukufaka idatha yeGrafu

Faka iDatha yeDatha

Ukuze uncede ngale miyalelo, khangela umzekelo womfanekiso ongentla

Kungakhathaliseki ukuba uluphi uhlobo lwetshathi okanye igrafu oyidalayo, isinyathelo sokuqala ekudaleni idilesi ye-Excel lihlala lifaka idatha kwiphepha lokusebenzela .

Xa ufaka idatha, gcina le mithetho engqondweni:

1. Ungashiyi imigca okanye iikholomu ezingenanto xa ufaka idatha yakho.
2. Faka idatha yakho kwiikholomu.

• Xa ubeka i- spreadsheet yakho, dwelisa amagama achaza idatha kwikholamu enye kwaye, ekunene kwaloo, idatha ngokwayo.
• Ukuba kukho uchungechunge olungaphezulu kweyodwa yedatha, babhale uluhlu emva kolunye kwiikholamu kunye nesihloko kwinqaku nganye yedatha phezulu.

Kule khokelo

1. faka idatha ekhoyo kwisigaba 8.

02 we-06

Khetha iDatha yeGrafa Data

Iinketho ezimbini zokukhetha iDatha yeDatha

Ukusebenzisa imouse

1. Drag ukhethe kunye neqhosha le mouse ukugqamisa iiseli eziqulethe idatha ukuba zifakwe kwigrafu yomgca.

Ukusebenzisa ikhibhodi

1. Cofa kwi-top left of data yegrafu yedatha.
2. Gcina phantsi iqhosha le- SHIFT kwibhodibhodi.
3. Sebenzisa izitshixo zitshixo kwibhodibhodi ukhethe idatha ukuba ifakwe kwigrafu yomgca.

Qaphela: Qiniseka ukuba ukhethe nayiphi na iikholomu kunye nezihloko zomqolo ozifunayo zifakwe kwigrafu.

Kule khokelo

1. Phakamisa ibhloko yeeseli ukusuka ku-A2 ukuya ku-C6, equka izihloko zekholomu kunye nezihloko ezilandelwayo

03 we-06

Ukukhetha Uluhlu lweGrafu lweNgcaciso

Ukukhetha Uluhlu lweGrafu lweNgcaciso

Ukuze uncede ngale miyalelo, khangela umzekelo womfanekiso ongentla.

1. Cofa kwiTybhu yerobhoni.
2. Cakraza kwicandelo leseshati ukuvula uluhlu lokuhlahla lweentlobo zegrafu ezikhoyo (Ukuhambisa isalathisi sakho semouse phezu kwegrafu hlobo kuya kuvelisa inkcazo yegrafu).
3. Cofa kwidiza yegrafu ukuyikhetha.

Kule khokelo

1. Khetha Faka> Umgca> Umgca ngeMakethi .
2. Umgca wesiseko wegrafu uyadalwa kwaye ufakwe kwiphepha lakho lokusebenzela. La maphepha alandelayo afomathiza ukufomathiza eli grafu ukufanisa igrafu yomgca eboniswe kwiNyathelo 1 yale khokelo.

04 we-06

Ukufometha Umgca weGrafu - 1

Ukufometha Umgca weGrafu - 1

Xa ucofa kwigrafu, iithebhu ezintathu - i-Design, Layout, kunye neTebhu zithebhu zongezwa kwibhebhoni phantsi kwesihloko seTrans Tools .

Ukukhetha isitayela somgca wegrafu

1. Cofa kwigrafu yomgca.
2. Cofa kwiThebhu yoyilo .
3. Khetha iSitayela 4 seStrip Styles

Ukongeza isihloko kwisitayela segrafu

1. Cofa kwiTyhu yoTywala.
2. Cofa kwiSihloko soTyati phantsi kwecandelo leeLebels .
3. Khetha ukhetho lwesithathu - Ngaphezulu kweTrart .
4. Thayipha kwisihloko esithi " Umyinge wokuNciphisa (mm) "

Ukutshintsha umbala wefonti yesihloko segrafu

1. Cofa kanye kwiSihloko soGrafu ukuyikhetha .
2. Cofa kwiThebhu yaseKhaya kwimenyu yebhondi.
3. Cofa kwinqolo engezantsi yenketho yoBume bePolisi ukuvula imenyu ehlayo.
4. Khetha Uluhlaza obomvu ngaphantsi kwecandelo eliqhelekileyo lemibala yemenyu.

Ukutshintsha umbala wefonti wegraf legend

1. Cofa kanye kwiGrafu Legend ukuyikhetha.
2. Phinda amanyathelo 2 - 4 ngenhla.

Ukutshintsha umbala wefonti wamabhile e-axis

1. Cofa kanye kwiileyibhile zenyanga ngaphantsi kwe- X axis i-horizontal ukukhetha.
2. Phinda amanyathelo 2 - 4 ngenhla.
3. Cofa kanye ngeenombolo ngaphaya kwe- axis Y ecacileyo ukuze ukhethe.
4. Phinda amanyathelo 2 - 4 ngenhla.

05 ka 06

Ukufometha Umgca weGrafu - 2

Ukufometha Umgca weGrafu - 2

Ukubala umgca wegrafu

1. Cofa kwiziko lemagrafu.
   
2. Cofa kwi- Shape Fill option ukuze uvule imenyu ehlayo.
   
3. Khetha i- Red, i-Accent 2, iLighter 80% ukusuka kwisiqendu se- Theme Colors kwimenyu.

Ukubala ummandla wengingqi

1. Cofa kwelinye lemizila yegridi eqondekileyo ukukhetha indawo yendawo yegrafu.
2. Khetha Izalathiso Yomfanekiso> Igradient> Kukhetho lwamaziko ukusuka kwimenyu.

Ukukhawulela umgca wegrafu

1. Cofa kwigrafu ukuyikhetha.
2. Cofa kwi-Shape Fill option ukuze uvule imenyu ehlayo.
3. Khetha iBravel> Umnqamlezo kwimenyu.

Ngeli nqanaba, igrafu yakho imele ifane negrafu yomgca eboniswe kwiNyathelo 1 yale khokelo.

06 we-06

Idatha yeTraphic Tutorial Data

Faka idatha engezantsi kwiiseli eziboniswe ukudala igrafu yomgca ehlanganiswe kule khokelo.

Cell - Data
I-A1 - Umyinge wokuNciphisa (mm)
A3 - Januwari
A4 - Epreli
A5 - Julayi
A6 - Oktobha
B2 - Acapulco
B3 - 10
B4 - 5
B5 - 208
B6 - 145
C2 - Amsterdam
C3 - 69
C4 - 53
C5 - 76
C6 - 74