Charting dates on the Y axis without weekends

[JenTK2006]

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.

 

[Tushar Mehta]

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