Mmene Mungapangire Chithunzi cha Gantt mu Google Mapepala

Chida chodziwikiratu cha kayendetsedwe ka polojekiti, ma chart Gantt amapereka ndondomeko yowonongeka, yosawerengeka yowerengeka ya ntchito zatsirizika, zamakono komanso zotsatila komanso omwe amapatsidwa ntchito pamodzi ndi masiku oyambirira ndi otsiriza. Chiwonetsero ichi chowonetseratu cha ndandanda chimapereka chithunzi chokwanira cha momwe zinthu zikuyendera bwino komanso zikuwonetsera zokhudzana ndi zomwe zingatheke.

Mapepala a Google amapereka mphamvu yokonza mapulogalamu a Gantt mwatsatanetsatane, ngakhale ngati simunaphunzirepo kale ndi maonekedwe awo apadera. Kuti muyambe, tsatirani malangizo awa pansipa.

01 a 03

Kupanga Ndandanda Yanu Yopangira Ntchito

Musanayambe kulowa mu Gantt chithunzi, muyenera kuyamba kufotokozera ntchito yanu pamodzi ndi maulendo awo ofanana patebulo losavuta.

1. Yambitsani Google Sheets ndi kutsegula spreadsheet yatsopano.
2. Sankhani malo abwino pafupi ndi pamwamba pa tsamba lanu lopanda kanthu ndipo lembani maina omwe akutsatira mzere womwewo, aliyense m'ndandanda yawo, monga momwe asonyezera chithunzichi: Kuyambira Tsiku , Kutsiriza , Dzina la Task . Kuti mudzipangitse kuti zinthu zikhale zosavuta mukamaliza maphunziro anu mungafune kugwiritsa ntchito malo omwe tagwiritsa ntchito mu chitsanzo chathu (A1, B1, C1).
3. Lowetsani ntchito iliyonse ya polojekiti yanu pamodzi ndi maulendo awo ofanana m'mizere yoyenera, pogwiritsa ntchito mizere yambiri yofunikira. Ayenera kulembedwa mwa dongosolo la zochitika (pamwamba mpaka pansi = poyamba kuti apite) ndipo fomu yamakono iyenera kukhala motere: MM / DD / YYYY.
4. Zina zomwe zimapangidwira mapepala anu (malire, shading, alignment, mapepala ojambula, ndi zina zotero) zimakhala zosavuta kwenikweni pa nkhaniyi, monga cholinga chathu chachikulu ndikulowetsa deta yomwe ingagwiritsidwe ntchito ndi Gantt chart pambuyo pake. Zonsezi ndi za inu ngati mungafune kusintha zina kuti tebulo likuwoneka bwino. Ngati mutero, nkofunika kuti deta yokha ikhalebe m'mizere ndi mizere yolondola.

02 a 03

Kupanga Pebulo Lophatikiza

Kungowonjezera tsiku loyambira ndi kutha sikukwanira kupereka tchati cha Gantt, momwe chigawochi chimadalira nthawi yeniyeni yomwe imadutsa pakati pa zinthu ziwiri zofunika kwambiri. Pofuna kuthana ndi zofunikirazi muyenera kupanga tebulo lina limene limapanga nthawiyi.

1. Pezani pansi mizere ingapo kuchokera pa tebulo yoyamba yomwe tilenga pamwambapa.
2. Lembani mayina omwe akutsogolera mumzere womwewo, aliyense m'ndandanda yawo, monga momwe asonyezera chithunzichi: Dzina la Task , Start Day , Total Duration .
3. Lembani mndandanda wa ntchito kuchokera pa tebulo lanu loyamba kulowa m'kalemba la Task Name , kuonetsetsa kuti iwo ali mndandanda womwewo.
4. Lembani ndondomeko zotsatirazi pa Qur'an ya Tsiku Loyamba pa ntchito yanu yoyamba, m'malo mwa 'A' ndi kalata yamphindi yomwe ili ndi Tsiku loyamba mu tebulo lanu loyamba ndi '2' ndi nambala ya mzere: = int (A2) -int ($ A $ 2 ) . Dinani kulowera kapena kubwereza makiyi atamaliza. Selo iyenera tsopano kusonyeza nambala ya zero.
5. Sankhani ndi kukopera selo imene mwangoyamba kumeneyi, pogwiritsa ntchito njira yachitsulo kapena Edit -> Koperani ku menu ya Google Sheets.
6. Mukamaliza kukonza mapepala ojambulawo, sankhani maselo otsalawo pa tsamba loyamba la Day Day ndipo pangani pogwiritsa ntchito njira yowonjezera kapena kusintha -> Sakanizani ku Masamba a Google. Ngati katchulidwa molondola, tsiku loyambira liyenera kuimira ntchito iliyonse liyenera kuwonetsa chiwerengero cha masiku kuyambira pachiyambi cha polojekiti yomwe yakhazikitsidwa kuyamba. Mungathe kutsimikizira kuti mndandanda wa Tsiku Loyamba mu mzere uliwonse ndi wolondola posankha selo yomwe ikugwirizana ndi kuonetsetsa kuti ndi ofanana ndi ndondomeko yomwe imayikidwa pamwendo wachinayi ndi chimodzi chodziwika, kuti mtengo woyamba (int (xx)) ukufanana ndi selo yoyenera malo anu tebulo lanu loyamba.
7. Chotsatira ndi Total Duration column, yomwe iyenera kukhala ndi njira ina yomwe ndi yovuta kwambiri kuposa yoyamba. Lembani zotsatirazi mu Total Duration gawo lanu ntchito yoyamba, m'malo malo ofotokozera maofesi ndi omwe ofanana ndi tebulo woyamba wanu spreadsheet (zofanana ndi zomwe tinachita mu step 4): = (int (B2) -int ($ A $ 2)) - (int (A2) -int ($ A $ 2)) . Dinani kulowera kapena kubwereza makiyi atamaliza. Ngati muli ndi vuto lililonse lokhazikitsa malo omwe akugwirizana ndi fayilo lanu, chinsinsi chotsatirachi chiyenera kuthandiza: (tsiku lomaliza ntchito ya ntchito - tsiku loyamba la polojekiti) - (tsiku loyamba la ntchito - tsiku loyamba la polojekiti).
8. Sankhani ndi kukopera selo imene mwangoyamba kumeneyi, pogwiritsa ntchito njira yachitsulo kapena Edit -> Koperani ku menu ya Google Sheets.
9. Mukamaliza kukonza mapepala ojambulawo, sankhani maselo otsalawo mu Total Duration column ndi kusunga pogwiritsa ntchito njira yachinsinsi kapena Edit -> Sakanizani ku menu ya Google Mapepala. Ngati zikopera molondola, Total Value phindu kwa ntchito iliyonse ayenera kusonyeza masiku onse masiku pakati pa nthawi yoyambira ndi kutha.

03 a 03

Kupanga Chithunzi cha Gantt

Tsopano kuti ntchito zanu zilipo, pamodzi ndi masiku awo ndi nthawi yake, ndi nthawi yopanga tchati cha Gantt.

1. Sankhani maselo onse mu tebulo lowerengera, kuphatikizapo mutu.
2. Sankhani njira yotsekera mu menyu ya Google Mapepala, yomwe ili pamwamba pa chinsalu mozemba pansi pa mutu wa tsamba. Pamene menyu yotsitsa ikuwonekera, sankhani Chati .
3. Tchati chatsopano chidzawoneka, chotchedwa Tsiku Loyamba ndi Total Duration . Sankhani ndondomeko iyi ndikuikako kuti mawonedwe ake apange pansi kapena pambali pa matebulo omwe mudapanga, mosiyana ndi kuwaphimba.
4. Kuwonjezera pa tchati yanu yatsopano, mawonekedwe a Tchati Editor adzawonekeranso kudzanja lamanja lanu. Sankhani Chithunzi cha Tchati , chopezeka pamwamba pa tabata la DATA .
5. Pendekera ku gawo la Bar ndipo sankhani njira yapakati, ndondomeko yamatabwa . Mudzazindikira kuti mndandanda wa tchati wanu wasintha.
6. Sankhani bukhu la CUSTOMIZE mu Mzere wa Zithunzi .
7. Sankhani Mutu wa Gawoli kuti uwonongeke ndikuwonetsera machitidwe omwe alipo.
8. Mu Apply kugwetsa pansi, sankhani Tsiku Loyamba .
9. Dinani kapena koperani Chosankha cha mtundu ndikusankha Palibe .
10. Tchati yanu ya Gantt tsopano yakhazikitsidwa, ndipo mukhoza kuyang'ana tsiku loyambira loyamba ndi Total Duration limasonyeza pozungulira pa malo awo omwe ali mu graph. Mukhozanso kupanga zina zomwe mukuzifuna kudzera mu Mkonzi wa Tchati - komanso kudzera pa matebulo omwe takhala nawo - kuphatikizapo masiku, mayina, maudindo, mapulani ndi zina. Kuboola kumene kulikonse mkati mwa tchatilokha kudzatsegule EDITI menyu, yomwe ili ndi zoikidwiratu zingapo.