chart Y-Axis dynamic maximum

Hello,
I got a bar chart, it shows percentages up to...yes 100%.
Usually, their is a series which are 20-30%, but once in a while
I get one value which is 100%.
If I leave the maximum unset...the bar chart resizes so that the area
show differences better for 20-30% series, however if a single 100%
value comes then the upper limit of the Y-Axis goes above 100%.
If I set the maximum then obviously the series of 20-30% look all
small...
Any ideas for putting in some expression into the maximum?
Thanks,
MattUnfortunately you cannot use expressions for the max and min (I too wanted
this). This feature will be available in RS 2005.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"yurps" <yurps@.yahoo.co.uk> wrote in message
news:1116341493.581592.139110@.f14g2000cwb.googlegroups.com...
> Hello,
> I got a bar chart, it shows percentages up to...yes 100%.
> Usually, their is a series which are 20-30%, but once in a while
> I get one value which is 100%.
> If I leave the maximum unset...the bar chart resizes so that the area
> show differences better for 20-30% series, however if a single 100%
> value comes then the upper limit of the Y-Axis goes above 100%.
> If I set the maximum then obviously the series of 20-30% look all
> small...
> Any ideas for putting in some expression into the maximum?
> Thanks,
> Matt
>