Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 1st 08, 04:12 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2007
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?

  #2   Report Post  
Old August 1st 08, 11:36 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 560
Default Gantt Chart - Grouping?

On Fri, 1 Aug 2008, in microsoft.public.excel.charting,
ant1983 said:
Got Office 2007 and trying to create a Gantt Chart. I got the basics down
but now need to adapt to what i want.


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 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.


You need to set your table out like this:

Start Duration
1 3 1
2 4 1
3 8 1
4 2 1
5 1 1
4 5 1

Make your stacked bar chart, then using Chart.. Chart Options.. Axes,
change the category axis to Time-scale. Now the bars at position 4 are
the same level.

(I just tried this for the first time: I'm amazed it even works!)

Now you'll have to use dummy axis techniques to create your driver
labels, because the category axis has to be integers for this
"Time-scale" trick to work, it can't be labels.

Driver
Johannes 0 1
Aaron 0 2
Geneve 0 3
Myrna 0 4
Wayne 0 5

Add the second and third columns using Paste Special, then convert the
series from stacked bar to XY (Scatter). Then use an add-in to label the
points with the first column, or just label them by hand.

PS I have no idea how you'll do this in Excel 2007, all I can say is it
works in Excel 97.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Gantt Chart lena_form Charts and Charting in Excel 2 May 12th 08 07:26 PM
Gantt Chart adel Charts and Charting in Excel 1 November 18th 06 01:38 PM
Gantt Chart? BChambers Charts and Charting in Excel 1 February 10th 06 07:07 PM
Gantt Chart centerNegative Charts and Charting in Excel 8 September 15th 05 05:05 AM
Gantt chart Aloysicus Charts and Charting in Excel 1 August 6th 05 11:32 PM


All times are GMT +1. The time now is 11:52 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017