Uyafuna ukufunda ukuthi kanjani yenza amagrafu ku-Excel ngendlela elula nesheshayo? Ngethuluzi lokushadi le-Excel, ungakwazi ukubona ngeso lengqondo idatha yakho ngendlela ecacile nesebenzayo, ezokusiza wenze izinqumo ezinolwazi empilweni yakho yomuntu siqu kanye neyomsebenzi. Nakuba kungase kubonakale kungaphezu kwamandla ekuqaleni, ngokuzijwayeza okuncane nolwazi mayelana nezinketho ezahlukene ezinikezwa uhlelo, uzobe udala amagrafu njengochwepheshe ngokushesha. Kulesi sihloko, sizokukhombisa isinyathelo ngesinyathelo indlela yokusebenzisa umsebenzi we-graphing ku-Excel ukuze ukwazi ukujabulisa abaphathi bakho, osebenza nabo, noma ukuze uzuze wena. Ake siqale!
- Isinyathelo ngesinyathelo ➡️ Yenza Amashadi ku-Excel
- Vula Microsoft Excel: Into yokuqala okufanele uyenze ukuvula i-Microsoft Excel kukhompyutha yakho. Ungayithola kumenyu yokuqala noma uyiseshe kubha yokusesha.
- Faka idatha yakho: Uma i-Excel isivuliwe, faka idatha yakho kumaseli ahambisanayo. Le datha izoba yisisekelo sokudala amagrafu akho.
- Khetha idatha: Chofoza bese uhudula ukuze ukhethe idatha ofuna ukuyifaka kugrafu yakho.
- Yiya kuthebhu ethi “Faka”: Phezulu esikrinini, chofoza ithebhu ethi "Faka" ukuze ufinyelele izinketho zezithombe.
- Khetha uhlobo lwegrafu: Ngaphakathi kwethebhu "Faka", khetha uhlobo lweshadi elimelela kahle idatha yakho, njengebha, ulayini, noma ishadi likaphayi.
- Enza ngendlela oyifisayo igrafu yakho: Uma ishadi selivela kusipredishithi sakho, ungalenza ngokwezifiso ngokushintsha umbala, wengeze isihloko namalebula, phakathi kwezinye izinketho.
- Londoloza igrafu yakho: Okokugcina, ungakhohlwa ukulondoloza igrafu yakho ukuze ukwazi ukuyisebenzisa noma kunini, kungakhathaliseki ukuthi kukhompyutha yakho noma ukwabelana ngayo nabanye.
Imibuzo Nezimpendulo
Indlela yokwenza igrafu ku-Excel isinyathelo ngesinyathelo?
- Vula I-Excel kanye khetha idatha ofuna ukuyifaka kugrafu.
- Umsebe chofoza kuthebhu ethi "Faka" phezulu esikrinini.
- Eqenjini elithi "Izithombe", khetha uhlobo lweshadi ofuna ukulenza.
- Se kuzokhiqiza igrafu enedatha ekhethiwe.
Indlela yokwenza ishadi lebha ku-Excel?
- Khetha idatha ofuna ukuyifaka eshadini lebha.
- Yiya kuthebhu ethi "Faka" futhi khetha »Ishadi Lebha» eqenjini elithi "Amashadi".
- Se kuzokhiqiza igrafu yebha enedatha ekhethiwe.
Indlela yokwenza igrafu yomugqa ku-Excel?
- Khetha idatha ofuna ukuyifaka eshadini.
- Umsebe chofoza kuthebhu »Faka» kanye khetha "Ishadi Lomugqa".
- Igrafu yomugqa kuzovela ngedatha ekhethiwe.
Indlela yokwenza ishadi likaphayi ku-Excel?
- Khetha idatha ofuna ukuyifaka eshadini likaphayi.
- Yiya kuthebhu ethi "Faka" futhi khetha "Ishadi Lophayi" eqenjini»Amashadi".
- Ishadi likaphayi izodalwa ngedatha ekhethiwe.
Ungabhala kanjani ishadi ku-Excel?
- Chofoza kugrafu ukuze uyikhethe.
- Kuthebhu ethi "Design", khetha "Engeza Into" bese kuthi "Isihloko Seshadi".
- Ubhala isihloko osifunayo segrafu.
Ungalushintsha kanjani uhlobo lweshadi ku-Excel?
- Chofoza eshadini ukuze uyikhethe.
- Kuthebhu ethi "Design", khetha "Shintsha Uhlobo Lweshadi" eqenjini elithi "Uhlobo Lweshadi".
- Khetha uhlobo olusha lweshadi ofuna ukulisebenzisa.
Ungalihlela kanjani ishadi ku-Excel?
- Chofoza eshadini ukuze uyikhethe.
- Chofoza ngakwesokudla ukuvula imenyu yezinketho zokuhlela.
- Khetha inketho ofuna ukuyihlela, njengesitayela, umbala noma amalebula.
Indlela yokwenza ishadi lokuhlakazeka ku-Excel?
- Khetha idatha ofuna ukuyifaka esakhiweni se-scatter.
- Yiya kuthebhu ethi "Faka" futhi khetha "Isakhiwo Sohlakazeka" eqenjini elithi "Izithombe".
- Isakhiwo sokuhlakaza kuzokhiqizwa ngedatha ekhethiwe.
Indlela yokwenza ishadi lendawo ku-Excel?
- Khetha idatha ofuna ukuyifaka eshadini lendawo.
- Yiya kuthebhu ethi "Faka" futhi khetha “Ishadi lendawo” eqenjini elithi “Amashadi”.
- Igrafu yendawo kuzovela ngedatha ekhethiwe.
Ungashintsha kanjani umbala weshadi ku-Excel?
- Chofoza eshadini ukuze uyikhethe.
- Kuthebhu ethi "Design", khetha "Imibala Esheshayo" eqenjini "Izitayela Zeshadi".
- Khetha uhlelo lombala ofuna ukulisebenzisa eshadini.
Ngingu-Sebastián Vidal, unjiniyela wekhompyutha ozifelayo ngobuchwepheshe kanye ne-DIY. Ngaphezu kwalokho, ngingumdali we tecnobits.com, lapho ngabelana khona ngezifundo zokwenza ubuchwepheshe bufinyeleleke kakhudlwana futhi buqonde wonke umuntu.