How to show every second label in a chart

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

therese_gule@hotmail.com - 19 Jan 2006 18:20 GMT

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? .........

Reply to this Message

William Stacey [MVP] - 19 Jan 2006 19:23 GMT

There are probably other ways to do it, but why not just create another
dataset that just contains the months of interest.

Signature

William Stacey [MVP]

|I have a stacked column chart shoving months from january 2004 to
| december 2005 on the x-axis: (This is a Category Group.)
[quoted text clipped - 3 lines]
|
| Any ideas how this is done? .........

Reply to this Message

therese_gule@hotmail.com - 20 Jan 2006 08:01 GMT

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.

Reply to this Message

Brian C. Berg - 31 Mar 2006 22:04 GMT

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.

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

Reply to this Message