Formula

H

Hartmut

I am created a table containing weekly total of overtime for a number of
employees (input table tab). I now want to create a chart (weekly overtime
tab) for the weekly overtime. I want to be able to enter a date for a
specific week and only create that week's chart.
Is there a function that can lookup a date in the input table and use the
numbers in the below rows to create the chart?
Any information is appreciated. Thanks in advance
 
P

Pete_UK

Yes, you could do this, but you need to supply a bit more detail. What
does your overtime sheet look like? A list of names in column A and
overtime in column B? Do you track this for each day, so do you also
have a date column? What do you want to plot on your chart? Hours vs
days or Hours vs people?

Pete
 
H

Hartmut

Thank you Pete for your reply. The "input tab" is layed out by using the "B"
column for the employee's names. In the subsequent columns i am entering only
the weekly total hours. Row 2, starting with C2, contains the week ending
date, i.e. 9/16/07, 09/23/07.

Now I like, if possible, enter on the charting tab one of the dates and
chart that particular week.

Again, thank you in advance for your help.
 
P

Pete_UK

As you emailed me directly, I've sent you a demo workbook. Perhaps you
can adjust it to suit your particular circumstances.

Hope this helps.

Pete
 
Top