Charting dates on the Y axis without weekends

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JenTK2006 - 20 Jul 2006 16:34 GMT

I need to graph employees' performance in turning in reports on time. So the
y axis is the date and the x axis is the employees' names. Is it possible to
eliminate weekends on the y axis? Otherwise, employees who turn in a report
Monday that was due Friday look like they are 3 days late, when actually they
are just one day late.

Signature

JenTK2006

Reply to this Message

Tushar Mehta - 22 Jul 2006 22:30 GMT

> I need to graph employees' performance in turning in reports on time. So the
> y axis is the date and the x axis is the employees' names. Is it possible to
> eliminate weekends on the y axis? Otherwise, employees who turn in a report
> Monday that was due Friday look like they are 3 days late, when actually they
> are just one day late.

I suspect you will have to do some calculations of your own in the worksheet
and plot the results. For starters, check out the WORKDAY and the
NETWORKDAYS functions. Note that both of them require the Analysis TookPak.

Signature

Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

Reply to this Message