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