Charting...

I'll be quick and too the point...
1: I have a stacked area chart.
2: Percentages are the values being marked.
Issue:
I need to make the 100 mark (text and line) on the y-axis to be red.
I've tried writing an expression to get at the current "label" for the
mark. I keep getting the following error:
<<
The border color expression for the chart 'Sample' contains an
error: [BC30456] 'value' is not a member of
'ReportExprHostImpl.EH_Sample.EH_ValueAxis'.
>>
Here's what I have: '=iif(me.Value,"Black", "Red")'
I've also tried .Text and .Label.
Any help would be appreciated.I gave you incomplete code. Here is what I currently have.
Here's what I have: '=iif(me.Value <> "100","Black", "Red")'|||Sorry, the color of the axis is not an expression.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stu" <stumiller@.unforgettable.com> wrote in message
news:1104275769.160878.21860@.z14g2000cwz.googlegroups.com...
>I gave you incomplete code. Here is what I currently have.
> Here's what I have: '=iif(me.Value <> "100","Black", "Red")'
>|||Brian Welcker [MS] wrote:
> Sorry, the color of the axis is not an expression.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Stu" <stumiller@.unforgettable.com> wrote in message
> news:1104275769.160878.21860@.z14g2000cwz.googlegroups.com...
> >I gave you incomplete code. Here is what I currently have.
> > Here's what I have: '=iif(me.Value <> "100","Black", "Red")'
> >
Brian,
Thanks for responding...
So, just to make sure I understand what your saying... there is no way
to get the "value" or "text" of an axis and change the style of that
axis based upon that value?
The reason I "ask" it again this way is that I am able to change the
color of the line and text with this statement:
'=iif(InScope("100"),"Black", "Red")'
Ofcourse, "100" is not within the scope of the data and all the lines
turn "Red" but the point being, I can change the style in the
expression. I'm just asking is there a way to determine what axis your
on.
Thanks|||Yes, lines are data so you can set their color to an expression. Axis values
aren't data so expressions don't really make any sense (we can't iterate
through all possible values). We would have to add an 'Axis value color'
property to the data point.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stu" <stumiller@.unforgettable.com> wrote in message
news:1104349698.883859.301160@.c13g2000cwb.googlegroups.com...
> Brian Welcker [MS] wrote:
>> Sorry, the color of the axis is not an expression.
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>> "Stu" <stumiller@.unforgettable.com> wrote in message
>> news:1104275769.160878.21860@.z14g2000cwz.googlegroups.com...
>> >I gave you incomplete code. Here is what I currently have.
>> > Here's what I have: '=iif(me.Value <> "100","Black", "Red")'
>> >
> Brian,
> Thanks for responding...
> So, just to make sure I understand what your saying... there is no way
> to get the "value" or "text" of an axis and change the style of that
> axis based upon that value?
> The reason I "ask" it again this way is that I am able to change the
> color of the line and text with this statement:
> '=iif(InScope("100"),"Black", "Red")'
> Ofcourse, "100" is not within the scope of the data and all the lines
> turn "Red" but the point being, I can change the style in the
> expression. I'm just asking is there a way to determine what axis your
> on.
> Thanks
>

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
>

Chart Axis

I have created a bar chart with percentages as the variables. The numbers on
the chart are correct, but the scale is incorrect. The scale adjusts to 100%
for all fields.
Anyone else encountered this problem?
--
TDWhen using percentages (e.g. format code P on the Y-axis), you can either
auto-scale the axis or you can specify an explicit min/max value. If you
specify an explicit max value (e.g. 120%), you have to specify it as 1.2
rather than 120
For percentages, 1 means 100%.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"TDahlin" <TDahlin@.discussions.microsoft.com> wrote in message
news:D87A2D0A-D607-4483-A3B4-484A07B2C5AC@.microsoft.com...
>I have created a bar chart with percentages as the variables. The numbers
>on
> the chart are correct, but the scale is incorrect. The scale adjusts to
> 100%
> for all fields.
> Anyone else encountered this problem?
> --
> TD