Simple question
 

Total newbie here.
I have 3 tables.
First table : group name
Second one : Start time of the working day ( also date )
Last one : End time of the working day ( also date )

Now when I click on chart wizard and I select for values the first
table and for X axis first the second column ( press control ) and also
the third one.

Now when I plot it I wished it was a graph with on the X axis the date
from the date the most far away from now untill the one nearest to now
like so:
26 august 2003 27august 2003 27 august 2004
And the Y axis the names.

So I look at the boxes presenting the names and I can tell when they
started working and when they stopped.

That kinda works but it only shows 2 groups and not all 50
And it ALWAYS starts the groups all at the same starting time
So when group1 starts at 3PM and group2 at 5PM they will both start at
say 3PM.

Help is very much appreciated


--
MasterMind
------------------------------------------------------------------------
MasterMind's Profile: http://www.excelforum.com/member.php...o&userid=27699
View this thread: http://www.excelforum.com/showthread...hreadid=472134

Gantt charts:

http://pubs.logicalexpressions.com/P...cle.asp?ID=343

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

MasterMind wrote:

Total newbie here.
I have 3 tables.
First table : group name
Second one : Start time of the working day ( also date )
Last one : End time of the working day ( also date )

Now when I click on chart wizard and I select for values the first
table and for X axis first the second column ( press control ) and also
the third one.

Now when I plot it I wished it was a graph with on the X axis the date
from the date the most far away from now untill the one nearest to now
like so:
26 august 2003 27august 2003 27 august 2004
And the Y axis the names.

So I look at the boxes presenting the names and I can tell when they
started working and when they stopped.

That kinda works but it only shows 2 groups and not all 50
And it ALWAYS starts the groups all at the same starting time
So when group1 starts at 3PM and group2 at 5PM they will both start at
say 3PM.

Help is very much appreciated