Tasklar\u0131m\u0131z\u0131n planlanan ba\u015flang\u0131\u00e7 tarihlerimizin var ve tasklar\u0131n s\u00fcrelerinin oldu\u011fu bir Excel’imiz var.<\/p>\n
Proje ba\u015flang\u0131\u00e7 tarihimiz ise 8 Haziran 2020<\/p>\n
Yapaca\u011f\u0131m\u0131z i\u015flemlerden sonra proje takibi i\u00e7in a\u015fa\u011f\u0131daki Gant Chartt raporunu elde etmek istiyoruz.<\/p>\n
Haydi ba\u015flayal\u0131m.<\/p>\n <\/p>\n \u0130\u015flerimizin ad\u0131, ba\u015flanaca\u011f\u0131 tarih ve harcanacak eforlar\u0131n\u0131n oldu\u011fu Excel tablomuz.<\/p>\n \u00dcst men\u00fcde bulunan butonlardan A\u015fa\u011f\u0131daki ekran \u00e7\u0131kt\u0131s\u0131nda g\u00f6rebilece\u011finiz gibi Gant Chartt raporu i\u00e7in grafik ekleme i\u015flemi yap\u0131yoruz.<\/p>\n <\/p>\n Eklenen bo\u015f grafi\u011fe sa\u011f t\u0131k yap\u0131p “Select Data<\/strong>” ile verilerimizi tan\u0131mlayaca\u011f\u0131z.<\/p>\n Select Data ‘y\u0131 t\u0131klad\u0131ktan sonra a\u00e7\u0131lan men\u00fcden sol k\u0131s\u0131mda bulunan “Add<\/strong>” butonuna t\u0131kl\u0131yoruz.<\/p>\n <\/p>\n Gant Chartt raporumuzu haz\u0131rlayabilmemiz i\u00e7in bizden ba\u015fl\u0131\u011f\u0131 ve verileri se\u00e7memizi isteyecek. A\u015fa\u011f\u0131daki \u00f6rnekteki gibi se\u00e7imimizi yap\u0131yoruz. Burada Projedeki i\u015flerin planlanan ba\u015flang\u0131\u00e7 s\u00fcrelerini belirleyece\u011fiz.<\/p>\n Tekrar ayn\u0131 sol k\u0131s\u0131mda bulunan “Add<\/strong>” butonuna bas\u0131yoruz. \u015eimdi de bu i\u015flerin ne kadar s\u00fcrece\u011fi ile ilgili verileri se\u00e7ece\u011fiz.<\/p>\n Kabaca Gant Chartt’\u0131 olu\u015fturduk \u015fimdi ince ayarlara gelelim.<\/p>\n Grafik \u00fcst\u00fcnde sa\u011f t\u0131k yap\u0131p “select data” dedi\u011fimizde a\u00e7\u0131lan men\u00fcden bu sefer sa\u011f k\u0131s\u0131mda bulunan ve otomatik dolan alan\u0131 d\u00fczenleyece\u011fiz. “Edit<\/strong>” butonuna basal\u0131m.<\/p>\n \u0130\u015f adlar\u0131n\u0131 se\u00e7elim. Olu\u015fturaca\u011f\u0131m\u0131z raporda g\u00f6r\u00fcnecekler.<\/p>\n \u0130\u015f adlar\u0131n\u0131n’da grafi\u011fe geldi\u011fini g\u00f6rm\u00fc\u015f olmal\u0131s\u0131n\u0131z. \u015eimdi grafik \u00fczerinde \u0130\u015f adlar\u0131n\u0131n oldu\u011fu k\u0131s\u0131ma sa\u011f t\u0131k yapal\u0131m ve “Format Axis<\/strong>” t\u0131klayal\u0131m.<\/p>\n “Categories in Reverse Order<\/strong>” i\u015faretini se\u00e7elim. b\u00f6ylece daha s\u0131ral\u0131 ve anlaml\u0131 bir grafik elde edece\u011fiz. Art\u0131k Gant Chartt raporumuzu olu\u015fturmaya \u00e7ok az kald\u0131.<\/p>\n Planlanan ba\u015flang\u0131\u00e7 zaman\u0131 ile ilgili alana grafik \u00fczerinde ihtiyac\u0131m\u0131z yok. Mavi bar’\u0131n \u00fczerine sa\u011f t\u0131k yapal\u0131m. “Format Data Series<\/strong>” i se\u00e7elim<\/p>\n Sa\u011f tarafta \u00e7\u0131kan men\u00fcden “no fill<\/strong>” i i\u015faretleyelim<\/p>\n Her\u015fey \u00e7ok g\u00fczel de proje ba\u015flang\u0131\u00e7 zaman\u0131ndan itibaren grafi\u011fin g\u00f6r\u00fclmesi daha anlaml\u0131 olacak onun i\u00e7in grafikte bulunan tarih k\u0131sm\u0131na sa\u011f t\u0131k yap\u0131p “Format Axis<\/strong>” i t\u0131klayal\u0131m.<\/p>\n Burada a\u015fa\u011f\u0131da g\u00f6rd\u00fc\u011f\u00fcn\u00fcz men\u00fcde “Minimum<\/strong>” de\u011ferine proje ba\u015flang\u0131\u00e7 zaman\u0131n\u0131n Numeric<\/strong> <\/span>format\u0131n\u0131 yazman\u0131z laz\u0131m. Bunun i\u00e7in proje ba\u015flang\u0131\u00e7 tarihini farkl\u0131 bir h\u00fccreye kopyalay\u0131p format\u0131n\u0131 numeric se\u00e7erseniz de\u011feri g\u00f6rebilirsiniz. G\u00f6rd\u00fc\u011f\u00fcn\u00fcz de\u011feri “Minimum” yazan yere yaz\u0131n.<\/p>\n Bu kadar. Gant Chartt’\u0131m\u0131z haz\u0131r a\u015fa\u011f\u0131daki \u00f6rne\u011fe bakarak tasar\u0131m\u0131nda de\u011fi\u015fiklikler yapabilirsiniz.<\/p>\n Umar\u0131m faydal\u0131 olmu\u015ftur.<\/p>\n \u0130\u015finize yarayabilecek baz\u0131 ba\u011flant\u0131lar:<\/p>\n
\n![\"\"](\"http:\/\/dijitalturk.com\/veysel\/wp-content\/uploads\/2020\/06\/DijitalTurk_Excel_Gantt_Chartt_Olusturma.png\")
<\/a><\/p>\n
\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n