Help with challenging chart

[curtis]

Hi everyone.

I have data from our backup server that is basically just
the server name, backup start and backup end time and date.
The data looks like this.

Server Start End Date
SOIDB2 19:01:34 19:39:09 9/9/2004
MOONDUST 19:01:35 19:18:20 9/9/2004
TERRIER 22:00:18 22:26:17 9/9/2004
SUNNA 22:00:18 22:49:10 9/9/2004
ONYX 22:00:19 22:04:19 9/9/2004
LARS 22:00:20 22:06:59 9/9/2004
SVEN 22:00:21 22:08:48 9/9/2004
EHUBUX 22:11:10 22:23:30 9/9/2004
GALAGA 0:00:32 0:19:29 9/10/2004
ISWEBDB 0:00:44 0:05:57 9/10/2004
BOOMER 0:10:12 0:12:27 9/10/2004

What I'd like to create is a chart that looks something
like this....where the shaded portions represent when the
backup was running for each server.

-------------------------------------------------
SOIDBB2 | XXXXXXXXXX
MOONDUST| XXXXXXXXXX
TERRIER | XXXXXXXXXXX
SUNNA | XXXXXXXXXXX
ONYX | XXX
LARS | XXXX
SVEN | XXXXX
EHUBUX | XXXXXXXXXX
GALAGA | XXXXXXXXX
ISWEBDB | XXXXX
BOOMER | XXXX
---------------------------------------------------
19:00 19:30 20:00 20:30 21:30 22:00 22:30 23:00

As it stands, all the rows are starting all the way on the
left, expand to the end of the backup time. This isn't an
accurate representation of what's going on.

Anyone have any tips on how I can make this chart?

 

[Andy Pope]

Hi curtis,

Take a look here,

http://peltiertech.com/Excel/Charts/FloatingColumns.html
http://peltiertech.com/Excel/Charts/GanttLinks.html

Cheers
Andy

 

[Curtis]

Thanks.... That should help a lot!

-----Original Message-----
Hi curtis,

Take a look here,

http://peltiertech.com/Excel/Charts/FloatingColumns.html
http://peltiertech.com/Excel/Charts/GanttLinks.html

Cheers
Andy


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
.