Unique Chart issue

[spam_only_please]

Well at least for me....

I'd like to represent some data from an access table- in a chart like
format- where the times worked by a crew of ten are graphically
dispalyed in a manner that shows how their shifts overlap/ relate.

So one shift displayed out on a grid labeled by the hours of the day,
side by side the other shifts, will not only show their total hours-
but also who else was working at the same time(s)....

I included an image to better explain what I'm after. Hopefully an
image in news group will go over ok...

Thanks in advance!

I'm always amazed at the wisdom of the groupand. This one has me
stumped (not like that is hard to do).

<a href="http://fyit.com/hours.jpg"> Example </a>

<img src="http://fyit.com/hours.jpg" />

[Ed Robichaud]

Assuming that you have work time records for each employee, try using the
Pivot Table autoform based on a query that contains the works records that
you want to compare. Make the multiple employee time records the "series",
the date on the horizontal/x axis and time/hrs on the vertical/y axis.
-Ed

<sp**************@comcast.net> wrote in message
news:11**********************@t31g2000cwb.googlegr oups.com...

Well at least for me....

I'd like to represent some data from an access table- in a chart like
format- where the times worked by a crew of ten are graphically
dispalyed in a manner that shows how their shifts overlap/ relate.

So one shift displayed out on a grid labeled by the hours of the day,
side by side the other shifts, will not only show their total hours-
but also who else was working at the same time(s)....

I included an image to better explain what I'm after. Hopefully an
image in news group will go over ok...

Thanks in advance!

I'm always amazed at the wisdom of the groupand. This one has me
stumped (not like that is hard to do).

<a href="http://fyit.com/hours.jpg"> Example </a>

<img src="http://fyit.com/hours.jpg" />

[spam_only_please]

I'm not having any luck with that..'

Maybe a good tutorial will do the trick. I'll look for one, or if
someone has a link?
Thanks

Ed Robichaud wrote:

Assuming that you have work time records for each employee, try using the
Pivot Table autoform based on a query that contains the works records that
you want to compare. Make the multiple employee time records the "series",
the date on the horizontal/x axis and time/hrs on the vertical/y axis.
-Ed

<sp**************@comcast.net> wrote in message
news:11**********************@t31g2000cwb.googlegr oups.com...

Well at least for me....

I'd like to represent some data from an access table- in a chart like
format- where the times worked by a crew of ten are graphically
dispalyed in a manner that shows how their shifts overlap/ relate.

So one shift displayed out on a grid labeled by the hours of the day,
side by side the other shifts, will not only show their total hours-
but also who else was working at the same time(s)....

I included an image to better explain what I'm after. Hopefully an
image in news group will go over ok...

Thanks in advance!

I'm always amazed at the wisdom of the groupand. This one has me
stumped (not like that is hard to do).

<a href="http://fyit.com/hours.jpg"> Example </a>

<img src="http://fyit.com/hours.jpg" />