Date format/grouping on x-axis label
 

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

Followup Question
 

Solved my question, but it didn't solve my problem.

Solution: Right-click on chart, select Chart Options, select Axes tab, and
change axis to Category.

I'll follow up my original post with another question.

I have the following data (formatting is going to be off, C=column):
C1 | C2 | C3 |C4
0609 | 50 | 10 | 5
0609 | 20 | 70 | 10
0610 | 10 | 20 | 30
0610 | 25 | 15 | 30
0610 | 50 | 70 | 90
etc.

I want a (bar) graph that looks like this:
70, 80, 15 | 85, 105, 150
0609 | 0610

I get a bar that looks like this:
50,10,5 | 20,70,10 | 10,20,30 | 25,15,30 | 50,70,90
0609 | 0609 | 0610 | 0610 | 0610

The formatting is butchering my example, but the | separates each column
grouping.

Is there a way to sum and group columns based on column 1?

Well, any help is appreciated
..

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


"Jay" wrote:

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