| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Charting count of unique dates in a list | Charts and Charting in Excel | |||
| Chart Dates on X Axis | Excel Discussion (Misc queries) | |||
| line graph-need to pick up dates as values for the x axis? | Charts and Charting in Excel | |||
| Charting data against dates where dates are not at fixed intervals | Charts and Charting in Excel | |||
| Formatting dates on x axis of chart...! | Excel Discussion (Misc queries) | |||
Linear Mode
