How to show every second label in a chart

I have a stacked column chart shoving months from january 2004 to
december 2005 on the x-axis: (This is a Category Group.)
jan-04, feb-04, mar-04,apr-04.... oct-05-nov-05, dec-05
I want to show only every second month.
Any ideas how this is done? .......There are probably other ways to do it, but why not just create another
dataset that just contains the months of interest.
--
William Stacey [MVP]
<therese_gule@.hotmail.com> wrote in message
news:1137694813.606325.155960@.g14g2000cwa.googlegroups.com...
|I have a stacked column chart shoving months from january 2004 to
| december 2005 on the x-axis: (This is a Category Group.)
| jan-04, feb-04, mar-04,apr-04.... oct-05-nov-05, dec-05
|
| I want to show only every second month.
|
| Any ideas how this is done? .......
||||I need to show the trend of the data for a period of 2 years on the
same line.
A way is to implement code with MOD to do this, but that again requires
a counter.|||Assuming that in your dataset you have a row for every month returned, you
can enter an expression in the Label property of your category group for the
months that uses the month field value when the RowNumber() function returns
an odd number and uses a zero-length string when the RowNumber function
returns an even number.
"therese_gule@.hotmail.com" wrote:
> I need to show the trend of the data for a period of 2 years on the
> same line.
> A way is to implement code with MOD to do this, but that again requires
> a counter.
>