Help with challenging chart

C

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

15 minute data to daily data 1
Problem formatting dates from CSV file 2
Tally the figures acquired from the same date 3
Cumulative chart 1
How do I have excel highlight days before & after a date on a cale 2
X axis collapsing to date on hourly data 9
Help!! find two number recurring numbers in row?? 1
Excel date formate doesn't change 0

Top