Shared resource usage chart
 

Hi,

I want to make a chart that shows how several users share one resource
over a period of time. Horizontal bars indicating the period of usage
for each user would be best. Is this possible to do with Excel, and if
so how do I do it?

Please see the attached image for a hint on what I'm trying to do
here.

Thank you!


+-------------------------------------------------------------------+
|Filename: chart.JPG |
|Download: http://www.excelforum.com/attachment.php?postid=3792 |
+-------------------------------------------------------------------+

--
h7h
------------------------------------------------------------------------
h7h's Profile: http://www.excelforum.com/member.php...o&userid=27086
View this thread: http://www.excelforum.com/showthread...hreadid=466017

Hi,

Sounds like a gantt chart. See Jon Peltier's article on the subject.
http://pubs.logicalexpressions.com/P...cle.asp?ID=343

Cheers
Andy

h7h wrote:
Hi,

I want to make a chart that shows how several users share one resource
over a period of time. Horizontal bars indicating the period of usage
for each user would be best. Is this possible to do with Excel, and if
so how do I do it?

Please see the attached image for a hint on what I'm trying to do
here.

Thank you!


+-------------------------------------------------------------------+
|Filename: chart.JPG |
|Download: http://www.excelforum.com/attachment.php?postid=3792 |
+-------------------------------------------------------------------+


--

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