Martin Griffiths
asked on
How to set the number of x-axis labels dependent on the number of categories in an ssrs 2005 chart
I have a report that shows a chart showing how much money has been made over a period of time. It reports the total money received at monthly intervals. As time goes on, there are more and more monthly totals so my x-axis is starting to look very cluttered. I know you can set this manually to display the label of every nth month by setting interval = n, but Is it possible to set the x-axis interval using an expression to say if either:
1) if the first/earliest month is more than say 3 years ago then set interval to 5
or
2) if there are > n number of categories (x-axis labels) then only display say every 5th category (month) xaxislabel.xls xaxislabel.xls
1) if the first/earliest month is more than say 3 years ago then set interval to 5
or
2) if there are > n number of categories (x-axis labels) then only display say every 5th category (month) xaxislabel.xls xaxislabel.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You could wait a bit to see if someone comes up with a clever solution to this problem. If not then I believe my first reply would be a valid answer (even though it doesn't solve your problem, it would mean that the problem is unsolvable).
So no upgrade to 2008 in the near future then?
So no upgrade to 2008 in the near future then?
ASKER
Wish that was a possibility but I very much doubt it seeing the organisation I work for!
ASKER
No other means of doing it in 2005 it seems.
ASKER