Pangani Flowcharts mu Excel

Kodi mudapatsidwapo ntchito yopanga ma flowchart kuti mupange mapu abizinesi mu bungwe. Makampani ena amalipira mapulogalamu okwera mtengo, apadera kwambiri omwe amapanga ma flowchart pamasitepe ochepa chabe ndikudina. Mabizinesi ena amakonda kugwiritsa ntchito zida zomwe zilipo zomwe zimakhala zosavuta mukangophunzira. Ena mwa iwo ndi Excel.

Konzani mayendedwe anu

Popeza kuti cholinga cha tchati chosonyeza mmene zinthu zidzakhalire, zisankho zimene zikupangidwa, ndi zotsatira za zisankhozo, n’zofunika kwambiri kuti anthu ambiri aimire zimenezi m’njira ya tchati. Ndipo amapeza kukhala kosavuta kuchita izi ngati atenga mphindi zochepa kukonza malingaliro awo. 

Ndipo ndithudi izo ziri. Ngati malingaliro anu saganiziridwa mokwanira, ndiye kuti flowchart sikhala yabwino.

Choncho, musanayambe mwachindunji kupanga flowchart, tikulimbikitsidwa kulemba zolemba zina. Mchitidwe umene adzachitikire nawo siwofunika kwambiri. Chinthu chachikulu ndikulemba gawo lililonse la ndondomekoyi, kuti mudziwe chisankho chilichonse ndi zotsatira zake.

Kukhazikitsa Zinthu

  1. Pitani ku tabu ya "Insert", komwe mupeza "Mawonekedwe".
  2. Pambuyo pake, mndandanda wa maonekedwe udzawoneka, wokonzedwa ndi magulu. Kenako, muyenera kuyang'ana mwa onsewo mpaka gulu la "Flowchart" litapezeka.
  3. Sankhani chinthu chofunikira.
  4. Kuti muwonjezere mawu, dinani kumanja pa chinthucho ndikusankha "Sinthani Malemba" kuchokera pazosankha.

Pomaliza, pa riboni ya Formatting, muyenera kusankha kalembedwe ndi mtundu wa flowchart.

Mukasankha chinthu chomwe mukufuna, muyenera kuwonjezera china cha chinthu china chake ndikupitilira mpaka gawo lililonse liwonetsedwe.

Kenako mawonekedwe omwe amawonetsa chinthu chilichonse cha flowchart ayenera kulembedwa. Kenako amene amachiwona amvetsetsa udindo uliwonse wa tchatichi ndi momwe chikugwirizanirana ndi ena.

Chiwerengero chilichonse chimagwira ntchito yake yokhazikika. Ngati mugwiritsa ntchito zinthu zachithunzicho molakwika, wina amene amachiwona akhoza kukumvetsani molakwika.

Nazi zina mwazinthu zofala kwambiri:

  1. Chiyambi kapena mapeto a tchati.
  2. Njira ya ntchito.
  3. Njira yodziwikiratu, monga machitidwe obwerezabwereza.
  4. Gwero la data. Itha kukhala tebulo, kapena mtundu wina wa zolemba, kapena tsamba lawebusayiti.
  5. Zosankha zomwe zatengedwa. Mwachitsanzo, ikhoza kukhala kuwongolera kulondola kwa njira yomwe idakonzedweratu. Kuchokera pa ngodya iliyonse ya rhombus pakhoza kukhala mizere yomwe imasonyeza zotsatira za chisankho chopangidwa.

Kuyitanitsa zinthu

Zinthu zikayikidwa pamalo oyenera, mutha kutsatira izi:

  1. Kuti mukonze zinthu mumndandanda, muyenera kusankha zinthu zingapo podina batani la SHIFT kenako kukanikiza chilichonse, kenako sankhani Sanjani Pakati pa tabu ya Format.
  2. Ngati mukufuna kupanga mipata yofanana pakati pa zinthu molunjika, ndiye kuti muyenera kusankha, kenako sankhani "Gawirani molunjika" pa tabu yomweyo.
  3. Kenako, muyenera kuonetsetsa kuti kukula kwa zinthu zonse ndi zofanana kuti tchaticho chiwoneke bwino.

Kupanga mzere wolumikizana

Pa tabu "Ikani" pali chinthu "Mawonekedwe" pomwe muyenera kusankha muvi. Zitha kukhala zowongoka kapena zopindika. Yoyamba imagwiritsidwa ntchito pazinthu zotsatizana. Ngati mukufunikira kubwereranso ku sitepe inayake mukamaliza ntchito zonse, ndiye kuti mzere wokhotakhota umagwiritsidwa ntchito.

Kodi yotsatira?

Mwambiri, Excel imapereka mawonekedwe ambiri opangira ma chart. Nthawi zina mukhoza kunyalanyaza miyezo ndi kuyatsa zilandiridwenso. Izi zidzangopindulitsa.

Siyani Mumakonda