08-08-2005, 01:33 PM
|
|
Registered User
|
|
Join Date: 05 Jul 2005
Posts: 19
|
|
Jon,
What I haven't been able to do from the get-go is even place the date values on any category axis and produce a working chart, so I still don't even understand the principle behind getting that working.
What I'd really like to know, is I've reviewed your tutorial here: http://peltiertech.com/Excel/Charts/GanttChart.html and I am wondering if along the bottom axis there is a way to reflect weekly (workday-only) values.
I can get this to work by creating a dummy series and labeling it along the bottom but the problem I am having is getting the chart to distinguish from actual calendar days and and my working formulas which are based on only workdays (by way of the WORKDAY and NETWORKDAYS worksheet formulas). So, once I create gridlines at major intervals of 5, the actual dummy series messes things up and gets off scale because it's tracking from a series that uses every calendar Monday, which it's still referencing as 7 intervals apart.
The only way around this I've found is manually typing in text values for each Monday. When I need to label 35 Mondays, though, this just isn't a quickly feasible or realistic solution. Also, it doesn't solve the problem of the chart bars being off from one another because of referencing a duration based on workdays onto an axis computing calendar days.
|