Yadda za a ƙirƙiri Shafin Gantt a cikin Google Sheets

Wani kayan aiki na musamman don gudanar da aikin, Gantt charts ya samar da jerin abubuwan da aka tsara, kwanan nan da za a iya kammala, ayyuka na yanzu da kuma ayyuka masu zuwa da kuma wanda aka sanya su tare da farawa da ƙarshen kwanakin. Wannan zane-zane na zane-zane yana ba da ra'ayi mai girma game da yadda ake ci gaba da ci gaba kuma yana nuna muhimmancin abin dogara.

Shafukan Google suna ba da damar ƙirƙirar cikakken Gantt daidai a cikin sakonninka, ko da idan ba ka da kwarewa ta baya da tsari na musamman. Don farawa, bi umarnin da ke ƙasa.

01 na 03

Samar da tsarin Jirginku

Kafin yin ruwa a cikin tsarin Gantt, kuna buƙatar farko don bayyana ayyukanku tare da kwanakinsu daidai a cikin tebur mai sauƙi.

1. Kaddamar da Google Sheets kuma bude sabon layi.
2. Zaɓi wuri mai dacewa a kusa da saman sashin layi na blank ka kuma rubuta a cikin sunayen sunayen da ke biye a jere guda ɗaya, kowanne a cikin shafi na su, kamar yadda aka nuna a cikin hoton hoton: Farawa , Ƙarshen Ranar , Sunan Taskalin . Don yin sauki a kanka a baya a cikin koyawa za ka iya so su yi amfani da wuraren da muka yi amfani dasu a misalinmu (A1, B1, C1).
3. Shigar da kowane aikin aikinku tare da kwanakinsu daidai a cikin ginshiƙai masu dacewa, ta yin amfani da layuka masu yawa kamar yadda ya cancanta. Dole ne a jera su saboda abin da ya faru (sama zuwa kasa = na farko zuwa ƙarshe) kuma kwanan wata ya zama kamar haka: MM / DD / YYYY.
4. Sauran nau'i nau'i na teburinku (iyakoki, shading, alignment, saintuna, da dai sauransu.) Sun kasance masu tsayayya a wannan yanayin, kamar yadda babban manufarmu shine shigar da bayanan da Gantt za ta yi amfani da shi a baya a cikin koyawa. Yana da gaba ɗaya a gare ku ko kuna son yin gyare-gyare da yawa don ganin tebur yana da sha'awa sosai. Idan kunyi, duk da haka, yana da muhimmanci cewa bayanai kanta sun kasance a cikin layuka da ginshiƙai daidai.

02 na 03

Samar da Kayan Shafi

Kamar shigar da farkon da ƙare kwanakin bai isa ba don yin Gantt ginshiƙi, kamar yadda layout dogara nauyi a kan ainihin lokacin da yake wuce tsakanin wadannan muhimman abubuwa biyu muhimmi. Domin kula da wannan buƙatar kana buƙatar ƙirƙirar wani layin da ke lissafin wannan lokaci.

1. Gungura ƙasa da layuka da dama daga tebur farko da muka halitta a sama.
2. Rubuta a cikin wadannan sunayen sunaye a jere guda ɗaya, kowanne a cikin shafi na su, kamar yadda aka nuna a cikin hotunan da aka hade: Sunan aiki , Farawa , Jimlar Dubi .
3. Kwafi jerin jerin ayyuka daga teburinku na farko a cikin Shafin Taskalin Rubutun, tabbatar da an tsara su a cikin wannan tsari.
4. Rubuta wannan maƙallin a cikin Shafin Farawa don aikin farko ɗinka, ya maye gurbin 'A' tare da harafin shafi wanda ya ƙunshi Ranar Farawa a cikin teburin farko da '2' tare da jere: = int (A2) -int ($ A $ 2 ) . Kusa da Shigar ko Komawa lokacin da aka gama. Ya kamata tantanin halitta ya nuna lambar zero.
5. Zaɓi kuma kwafe tantanin salula wanda ka shigar da wannan tsari kawai, ko dai ta amfani da gajeren hanya na keyboard ko Shirya -> Kwafi daga menu na Google Sheets.
6. Da zarar an kwashe ma'anar zuwa akwatin allo, zaɓi dukkanin sauran jikin a cikin Shafin Farawa da kuma manna ta amfani da gajeren hanya na keyboard ko Shirya -> Taɗa daga menu na Google Sheets. Idan an kwafe shi daidai, darajan Farawa ga kowane ɗawainiya ya kamata ya nuna yawan kwanakin daga farkon aikin da aka saita don farawa. Kuna iya tabbatar da cewa tsarin Farawa a kowace jere daidai ne ta hanyar zabar tantanin halitta wanda ya dace da kuma tabbatar da cewa yana da kama da tsarin da aka rubuta a mataki na 4 tare da batu ɗaya, wanda ƙimar farko (int (xx)) ya dace da cell wuri a cikin teburinku na farko.
7. Kashi na gaba shine jimlar Duration , wanda yake buƙatar zama tare da wani tsari wanda ya fi rikitarwa fiye da na baya. Shigar da wadannan zuwa cikin Jimlar Dubawa na tsawon aikinku, ya maye gurbin bayanan salula tare da waɗanda suka dace da na farko da tebur a cikin sakonninku na ainihi (kamar abin da muka yi a mataki na 4): = (int (B2) -int ($ A $ 2)) - (int (A2) -int ($ A $ 2)) . Kusa da Shigar ko Komawa lokacin da aka gama. Idan kana da wasu al'amurran da suka shafi tantanin halitta waɗanda suka dace da maƙallanka na musamman, maɓallin dabarar ya kamata ya taimaka: (ƙarshen kwanan aiki na ƙarshe - kwanan fara aiki) - (aikin kwanan wata na yanzu - kwanan fara aiki).
8. Zaɓi kuma kwafe tantanin salula wanda ka shigar da wannan tsari kawai, ko dai ta amfani da gajeren hanya na keyboard ko Shirya -> Kwafi daga menu na Google Sheets.
9. Da zarar an kwashe ma'anar zuwa akwatin allo, zaɓi dukkanin sauran jikin a cikin Kwanakin Dubi Tsawon Dubawa da kuma manna ta amfani da gajeren hanya na keyboard ko Shirya -> Taɗa daga menu na Google Sheets. Idan an kwafa shi daidai, Ƙididdiga na tsawon lokaci na kowane ɗawainiya ya kamata yayi la'akari da yawan adadin kwanakin tsakanin kwanakin farko da ƙarshen kwanakinsa.

03 na 03

Samar da Gantt Chart

Yanzu cewa ayyukanku suna cikin wuri, tare da kwanakin da suka dace da lokaci, lokaci ya yi don ƙirƙirar ginshiƙi Gantt.

1. Zaɓi dukkan kwayoyin cikin layin lissafin, ciki har da rubutun kai.
2. Zaɓi Zaɓin Zaɓuɓɓuka a cikin Google Sheets menu, wanda yake zuwa saman allon kai tsaye a ƙarƙashin sunan aikin aiki. Lokacin da menu mai saukewa ya bayyana, zaɓi Shafin .
3. Za'a bayyana sabon sigogi, mai taken Sun Farawa da Kwanakin Dubi . Zaɓi wannan zane kuma ja shi don alamarsa ta sanya shi a ƙasa ko kusa da gefe da teburin da ka ƙirƙiri, kamar yadda ya saba wa overlaying them.
4. Bugu da ƙari ga sabon siginarku, zaɓin Edita na Chart zai kasance a bayyane a hannun dama na allonku. Zaɓi Nau'in siginar , an gano zuwa saman DATA ta .
5. Gungura ƙasa zuwa Sashin Bar kuma zaɓi zaɓi na tsakiya, Siffar ma'auni . Za ku lura cewa shimfidar layinku ya canza.
6. Zaɓi mahadar CUSTOMEN a cikin Editan Edita .
7. Zaɓi jerin sashe don haka ya rushe kuma ya nuna saitunan da ake samuwa.
8. A cikin Aiwatar don saukarwa, zaɓi Fara Ranar .
9. Danna ko danna Zaɓin Zaɓin kuma zaɓi Babu .
10. An riga an halicci layin Gantt ɗinku, kuma za ku iya ganin mutumin da ya fara Farawa da yawancin lambobi na tsawon lokaci ta hanyar yin la'akari da yankunansu a cikin zane. Zaka kuma iya yin wasu gyare-gyare da kake so ta hanyar Editan Edita - da kuma ta cikin Tables da muka halitta - ciki har da kwanakin, sunayen aiki, lakabi, tsarin launi kuma mafi. Danna-dama a ko'ina a cikin sashin kanta zai bude maɓallin EDIT , wanda ya ƙunshi saitunan saituna.