Thread: 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!

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