Sunday, August 18, 2019

cara asas utk buat gantt guna excell

1. buat senarai
2. format date ( d-mmm)
3. buta bat chart
https://www.youtube.com/watch?v=-oD50HSBBBI
4. data series
 a) start date - tekan tajuk + select data
b) duration - tekan tajuk + select data
c) edit categori axis - select nama task
** data tak match
5. select graf di senarai kiri
 - pilih format axis + categori in inverse order

No comments:

Post a Comment