Best Line chart to use?

  • Thread starter Thread starter Kurt_wylde
  • Start date Start date
K

Kurt_wylde

I'm trying to create a chart that shows the run time (in minutes) o
data backups at work.

They start at various times from 00:00 to 23:59, with varying lengths.

3-D looks the best on paper, where it seems best to have the 24 hou
clock across the x-axis with the run time as the Z-axis. I then need t
somehow have each server running 'into' the graph for the run time
This allows me to have a few 'stacked' on top of each other in cas
multiple servers all start to backup at say, 03:00.

Only I can't get it to work..lol

Can you suggest a more relevant chart type, or if not, how I can solv
this puzzle..?

Thanks a lot..
 
Kurt -

Do you want a Gantt chart? You list the servers along the left hand
vertical axis. If server A started at 03:00 and ended at 03:30, you get
a horizontal bar from 03:00 to 03:30 at the level of A. If Server B
started at 03:00 but ran until 04:00, your bar would start where A's bar
started, but it would run twice as long.

Some links:

Gantt Charts in Microsoft Excel
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=343
Gantt Chart Links
http://peltiertech.com/Excel/Charts/GanttLinks.html

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

That is EXACTLY what I want..!!
The floating chart on the link you gave is perfect.. If I were 'that
way inclined, I'd give you a kiss..haha.

Thanks again..

K:
 
Back
Top