08-11-2005, 11:05 AM
|
|
|
|
Re: Gantt Chart
This all becomes much more complicated if you need to use workdays
instead of all days. Workdays isn't an easy linear scale of dates
anymore. You need to convert the start and end dates to a number of
workdays from a reference point, then realize your "date" axis is really
just an elapsed workdays axis.
Use a technique like this, with your monday dates as labels and the
elapsed workdays for each Monday as X values of the dummy axis series:
http://peltiertech.com/Excel/Charts/ArbitraryAxis.html
To easily whip off the Mondays, place your first date in a cell, under
it write a formula incrementing this by 7 (7 days per week), and drag it
down as far as you need.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
centerNegative wrote:
> 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.
>
>
|