07-18-2005, 11:05 PM
|
|
|
|
Re: Gantt Chart
Time scale to category won't work on a value axis.
I'd suggest recoding the dates into values, so Mon to Fri of week 1 are 1 to 5, Mon
to Fri of week 2 are 6 to 10, etc. Use these in the chart. Then use this technique
to put some dummy labels onto the horizontal axis of the chart:
http://peltiertech.com/Excel/Charts/ArbitraryAxis.html
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
centerNegative wrote:
> Has anyone had a chance to review this? I have now spent a full week
> trying establish a timeline/Gantt/project schedule-style chart that
> covers only weekdays and haven't had any luck. Is there possibly a way
> to have the charting feature read all values from cells - i.e., series
> labels, data labels, catagory labels, value labels so that I can just
> fill them in with the values I want and have them appear in the chart?
>
> I really wouldn't mind filling in all these values myself and having
> the chart just use them in appearance. All I want out of the chart is
> graphic usability.
>
> I've seen many posts about people having timeline axes that displayed
> weekends when they didn't want them displayed and solved the problem by
> switching the axis from Time-scale to Category. I haven't even been able
> to re-create this problem or solution. Is there a way to accomplish this
> with overlay charts? Please, please, I am now *begging * for help.
>
> Here's basically what I am trying to achieve using one task:
>
> Code:
> --------------------
> __________________
> Construction........ | |__________________| |
> |_._._._._|_._._._._|_._._._._|_._._._._|_._._._._|
> 6/6/05 6/13/05 6/20/05 6/27/05 7/04/05 7/11/05
> --------------------
>
>
|