hi all, i am having ssrs 2008 r2 report in that I have one bubble chart. For the Chart Grid Lines of this chart , I only want to show one line at value for ex., 50% . so for all the values which are less than 50% should come below this grid line and all the values which are more than 50% should come above this grid line. may i know where am i suppose to write this condition? And the expression I am using in "Values" field of chart is this :- =Sum(val(Fields!GF.Value)) / Sum(val(Fields!CNT.Value)) and it has been applied percentage value. so, if this expression has values more than 50% then all those values should come above that grid line and if this expression has values less than 50% then all those values should come below that grid line. In short, I have to display only one grid line to seperate values above and below 50%

any idea with ?

any idea with ?

any idea with.?

pelase give any hints for this.

any idea on this?

Hi, In order to display only one grid line for 50%, please refer to the steps below: 1. If the grid line is disabled, please right click the axis and check Show Major Gridlines. 2. Select the grid line, in the properties pane, specify the Interval property to 1, and specify the IntervalOffset property to 0.5. After that, only one grid line for 50% will be displayed in the chart when the report is rendering. Thanks, Tony Chain Tony Chain [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Hi Tony, Setting that property now I am able to get only one grid line for 50% so that is fine. But it is displaying that 50% line at different positions for different inputs(data). How can we make it such a way that that 50% line always stays at middle of the chart all the time. (currently, 50% line sometimes comes to near top , sometimes come to middle and sometimes come to near bottom of the chart. we wanna make it fix at middle. i guess some interval needs to be set for Y axis) can you advise?

Hi UltraDev, Sorry fo delay. In order to make the 50% line always stays at middle of the chart, we need to specify the Maximum and Minimum properties of the Y-Axis by the steps below: Select the Y-Axis in the chart. In the Properties pane, specify the Maximum property to 1 and specify the Minimum property to 0. Thanks, Tony ChainTony Chain [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Yup that worked.

Hi Tony, Again, can you advise, if I want to display label "50" for that one and only middle line at 50% then how can we do that? Hope to get an answer Thanks,

setting "LabelInterval" to 1 and "LabelIntervalOffset" to 0.5 and after that setting the "LabelsFormat" to 0% and it will display 50% label only at that fixed middle line. this solves the problem.