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



--
Message posted from http://www.ExcelForum.com

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/P...cle.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/
_______


Kurt_wylde < wrote:

> I'm trying to create a chart that shows the run time (in minutes) of
> 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 hour
> clock across the x-axis with the run time as the Z-axis. I then need to
> 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 case
> 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 solve
> this puzzle..?
>
> Thanks a lot..
>
> K
>
>
> ---
> Message posted from http://www.ExcelForum.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:

--
Message posted from http://www.ExcelForum.com

That's okay, a simple Thank You will suffice.

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

Kurt_wylde < wrote:

> 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
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>