Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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.
 
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
 
Back
Top