Hello all,

I known I've seen this answered, but I can't find the original post, so I
have to repost.

I have a column of dates as a category x axix label.

It is formatted to mmm-yy (Jan-07). This works great, until I add a blank
value into the column.

Column1
9/26/2006 (formatted to: Sep-06)
9/26/2006 (formatted to: Sep-06)
10/24/2006 (formatted to: Oct-06)
10/24/2006 (formatted to: Oct-06)
10/25/2006 (formatted to: Oct-06)
10/27/2006 (formatted to: Oct-06)
11/11/2006 (formatted to: Nov-06)

The chart looks like this:

-----------------------------
Sep-06 | Oct-06 | Nov-06

If I add the value (blank) as one of the cell values (for an unknown), I get
this:

----------------------------------------------------------------------------------
Sep-06 | Sep-06 | Oct-06 | Oct-06 | Oct-06 | Oct-06 | Nov-06 | (blank)

I can't figure out how to group the similar months together, and keep the
blank/unknown date. I recall something about making the axis or column a
category, but I can't figure out how to do it, or if I'm even on the right
track.

Any help is appreciated.

Thanks,
Jay

Disregard, this is so I can find my post later.
***postedbyJay***