Charting dates on the Y axis without weekends

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

Guest

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 said:
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.
Click to expand...
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
 
Back
Top