Category (X) Axis Time-Scale Greyed Out

[okrick@gmail.co]

The source data for the X axis is by month (dates formatted as mmm yy) but I can't select Time-scale for the Primary X axis.

I can change the formatting for the X-axis values to m/d/yy and back to mmm yy so I know the source is actually a date.

What I'm trying to do is have excel fill in the missing months as zeros in the graph. I'm using a line with markers and some of the pivot table fields are plotting as points only with no line between. I expect the line to drop to zero for the months between data points.

I am using Excel 2003 and I'm a dunce with charts.

What am I doing incorrectly?

Thanks,

Rick

[oldchippy]

Does this link help?

http://www.andypope.info/charts/brokenlines.htm