WRT changing the base units to months, if I do this then I only get one
value for that month. The major and minor units have to be months as well.

I was telling what would go wrong if you changed the base unit to
months. Not clearly enough.

WRT xaxis = category, if I choose this then the date order is gone.

Here is the matrix I'm charting on:
date series1
5-Apr-04 5
25-Jan-04 2
15-Mar-04 4
10-Mar-04 3
10-Jan-04 1

If you want date order, but don't care about proportional spacing, then
sort the worksheet by date, then use the category axis type.


- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______