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


--
centerNegative
------------------------------------------------------------------------
centerNegative's Profile: http://www.excelforum.com/member.php...o&userid=24921
View this thread: http://www.excelforum.com/showthread...hreadid=387621