Charting dates on the Y axis without weekends
 

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.
--
JenTK2006

Charting dates on the Y axis without weekends
 

In article , JenTK2006
@discussions.microsoft.com says...
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.

--
Regards,

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