By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,482 Members | 2,438 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,482 IT Pros & Developers. It's quick & easy.

Unique Chart issue

P: n/a
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" />

Apr 27 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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" />

Apr 27 '06 #2

P: n/a
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" />


Apr 27 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.