cara Membuat gantt chart di excel

download  sample file for learning : Create Gantt Chart with excel

gantt chart

create gantt chart di excel , membuat gantt chart di excel

create table sesuai sample
block table, insert chart, pilih bar chart (staked bar)

right click dibar chart tsb, pilih select data

click edit yg dibawah legend entries
ganti series name dari duration dgn select data, start (hy pilih cell b1)
ganti series value dgn select data, dgn data tanggal di start ( blok dr atas ke bwah (cell b2:b7)

clik ok

right click lagi, dichart tsb,
select data
add

pilih series name dgn select data, duration (hy pilih cell e1)
ganti series value dgn select data, dgn data duration ( blok dr atas ke bwah (cell e2:e7)

clik ok
muncul 2 warna chart

double click chart yg biru
diformat data series, muncul menu paling kanan, ubahlah fill dgn no fill, dan border dgn no line

abrkadaba, hy muncul gantt chart anda,
selesai bleum lah

click pilih sumbu y,

di axis option, click categories in reverse order, tujuan dibalik yg dibawah menjadi diatas

terakhir pilih lagi di sumbu y, lalu right click
pilih select data
click edit, edit ini yg dibawah horizontal,
ganti select data, ke cell D2:D7
click OK

jadilah gantt chart anda

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s