Formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hartmut - 25 Sep 2007 22:54 GMT

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

Reply to this Message

Pete_UK - 25 Sep 2007 23:28 GMT

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

On Sep 25, 10:54 pm, Hartmut <Hart...@discussions.microsoft.com>
wrote:

> 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
[quoted text clipped - 3 lines]
> numbers in the below rows to create the chart?
> Any information is appreciated. Thanks in advance

Reply to this Message

Hartmut - 26 Sep 2007 14:54 GMT

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.

> 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
[quoted text clipped - 13 lines]
> > numbers in the below rows to create the chart?
> > Any information is appreciated. Thanks in advance

Reply to this Message

Pete_UK - 26 Sep 2007 22:38 GMT

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

> 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
[quoted text clipped - 25 lines]
>
> - Show quoted text -

Reply to this Message

Rate this thread: