Nigute ushobora gukora imbonerahamwe ya ganta muri excel

Anonim

Nigute ushobora gukora imbonerahamwe ya ganta muri excel

Mu rubanda runini runini, rushobora kubakwa hakoreshejwe gahunda ya Microsoft Excel, ugomba guhitamo cyane cyane imbonerahamwe ya GANTA. Ni imbonerahamwe ya horizontal, kuri axontal ya horizontal yigihe giherereye. Hamwe nayo, biroroshye cyane kubara no kwerekana ibice byigihe gito. Reka tumenye uburyo bwo kubaka imbonerahamwe ya Ganta muri Excel.

Gukora imbonerahamwe ya Ganta muri Excel

Erekana amahame yo gukora imbonerahamwe ya Ganta nibyiza kurugero runaka.

  1. Dufata imbonerahamwe y'abakozi b'imishinga, aho itariki yo gusohora mu biruhuko n'umubare w'iminsi mikuru ikwiye yerekanwe. Kugirango uburyo bwo gukora, birakenewe kugira inkingi aho amazina yabakozi adafite uburenganzira, bitabaye ibyo umutwe ugomba kuvaho.
  2. Inkingi idafite umutwe muri Microsoft Excel

  3. Ubanza twubaka igishushanyo. Kugira ngo dukore ibi, tugenera agace k'ameza, bifatwa nk'ishingiro ryo kubaka. Jya kuri tab "shyiramo" hanyuma ukande kuri "umurongo-" buto iherereye kuri kaseti. Kurutonde rwubwoko bwibishushanyo bigaragara, hitamo ubwoko ubwo aribwo bwose bwimboneranye. Dufate muri iki kibazo cyacu bizaba gahunda nini.
  4. Kubaka imbonerahamwe ya Microsoft Excel

  5. Nyuma yibyo, excel izakora iki gishushanyo.
  6. Igishushanyo cy'umurongo muri Microsoft Excel

  7. Noneho dukeneye gukora umurongo wambere wubururu kugirango igihe cyibiruhuko gusa gigume mu gishushanyo. Kanda iburyo ahantu hose ubururu bwiki gishushanyo. Muri menu, hitamo "imiterere yumurongo wamakuru ...".
  8. Inzibacyuho Kuri imiterere yumubare muri Microsoft Excel

  9. Jya mu gice cya "Kuzuza", twashizeho switch kuri "oya" hanyuma ukande kuri buto "gufunga".
  10. Kuraho Kuzuza umurongo muri Microsoft Excel

  11. Amakuru ku gishushanyo iherereye munsi, ntabwo byoroshye gusesengura. Tuzagerageza kubikosora: ukanze buto iburyo bwimbeba kuruhande, aho amazina yabakozi aherereye. Muri menu, genda muburyo bwa "umurongo wa axis".
  12. Inzibacyuho Imiterere ya Axis muri Microsoft Excel

  13. Mburabuzi, tugwa mu gice "Ibipimo by'inyuguti", aho dushyira akamenyetso ahateganye n'ibyiciro "hanyuma tukande" hafi ".
  14. Guhindukira kumurongo winyuma yibyiciro muri Microsoft Excel

  15. Umugani ntabwo ukenewe mugishushanyo cya GANTA. Kuyikuraho, hitamo buto yimbeba hamwe no gukanda imbonerahamwe hanyuma ukande urufunguzo rwo gusiba kuri clavier.
  16. Gusiba Umugani muri Microsoft Excel

  17. Nkuko tubibona, igihe gitwikiriye imbonerahamwe kirenga imipaka yumwaka wa kalendari. Urashobora gukora mugihe cyumwaka cyangwa ikindi gice icyo aricyo cyose ukanze kuri axis aho amatariki ashyizwe. Muri menu igaragara, hitamo "umurongo wa axis".
  18. Jya kumiterere ya horizontal axis muri Microsoft excel

  19. Kuri "Ikiganiro cya Axis" hafi yigenamiterere "agaciro ntarengwa" na "Agaciro ntarengwa", duhindura uburyo bwa "auto" muburyo bwa "Itunganijwe". Twashizeho indangagaciro zamatariki mumadirishya ahuye dukeneye. Ako kanya, niba ubishaka, urashobora gushiraho igiciro cyamacakubiri yibanze kandi hagati. Idirishya rirashobora gufungwa.
  20. Gushiraho indangagaciro zihamye muri Microsoft Excel

  21. Kurangiza guhindura imbonerahamwe ya GANTATA, hasigaye kuzana izina rye. Jya kuri tab "imiterere" hanyuma ukande kuri "Igishushanyo Umutwe". Kurutonde rugaragara, hitamo agaciro "hejuru yigishushanyo."
  22. Kugenera Izina ryigishushanyo muri Microsoft Excel

  23. Mu murima aho izina ryagaragaye, andika izina iryo ariryo ryose, rikwiriye.
  24. Izina rya Diam muri Microsoft Excel

  25. Birumvikana, urashobora kandi guhindura isura yibisubizo zabonetse, bikaguha ibyo ukeneye nuburyo butagereranywa, hafi kugeza igihe kitagira iherezo, ariko muri rusange imbonerahamwe ya Gantta iriteguye.
  26. Imbonerahamwe ya gantt muri Microsoft Excel Yiteguye

    Nkuko rero tubibona, kubaka imbonerahamwe ya Ganta ntabwo bigoye cyane, nkuko bigaragara mbere. Algorithm yasobanuwe haruguru irashobora gukoreshwa kubarabungamari gusa no kugenzura ibiruhuko, ahubwo no gukemura indi mirimo myinshi.

Soma byinshi