View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
ant1983 ant1983 is offline
external usenet poster
 
Posts: 12
Default Gantt Chart - Grouping?

Hey!!!

Got Office 2007 and trying to create a Gantt Chart. I got the basics down
but now need to adapt to what i want. Here's what i got followed by what i
want to achieve:

WHAT I GOT:
My table looks like this:

Task Start Duration Driver
Task 1 3 1 Johannes
Task 2 4 1 Aaron
Task 3 8 1 Geneve
Task 4 2 1 Myrna
Task 5 1 1 Wayne
Task 6 5 1 Myrna

I can create a basic Gantt Chart from that by select the first 3 columns.

WHAT I WANT TO DO:

I actually want to show the gantt by Driver NAme as the Vertical Category
Axis and obviously only show the driver's name once i.e. in the data above i
want to show Myrna's name once and not twich although it appears twich in the
table. I then want to show the two "points" in that same row...

How do i do this?