Gantt - format
 

I have excel 2007
I have a table like this

Start Date Duration Staff Staff 2
JOB 1 5/1/2009 29 Bob Dan
JOB 2 5/1/2009 60 Jeff Denise
JOB 3 5/15/2009 61 Ben Dan
JOB 4 5/15/2009 61 Jeff Paul

Gantt - format
 

What I wanted to say before it posted was -
I want each person on these jobs to have their own color and do it so each
job is only listed once on the x-axis.
possible?
thanks!

"KKay" wrote:

I have excel 2007
I have a table like this

Start Date Duration Staff Staff 2
JOB 1 5/1/2009 29 Bob Dan
JOB 2 5/1/2009 60 Jeff Denise
JOB 3 5/15/2009 61 Ben Dan
JOB 4 5/15/2009 61 Jeff Paul