Hi, I have created a bubble chart in SSRS 2008. My datasource is AS 2005. I want my two axes to cross at 0 but I am not finding the option for that in the axes properties. I have done the same in excel where there was an option to make the axes "cross at 0". Can someone please point me how to do the same in RS 2008 bubble chart. Thanks in advance, ~Suman

Hi Guys, Any ideas on how to achieve the above requirement.

Hi Suman, Based on your information, you want the X-Axis and Y-Axis cross at zero, to this requirement, please follow to these: 1. Right-click the X-Axis and then select Axis Properties. 2. Then you will see Cross at drop-down list on the Axis Properties dialog box. 3. Type in zero in the drop-down list. 4. Do the same as Y-Axis. If you have any question, please feel free to ask. Thanks,Challen Fu [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 Suman, You can look at Nevron Chart for SSRS. I think the following topic will assist you with your requirements: http://support.nevron.com/KB/a143/cross-chart-axis-at-specified-value-or-percent-in-ssrs.aspx I hope this helps. Einar

Hi Suman, You can look at Nevron Chart for SSRS. I think the following topic will assist you with your requirements: http://support.nevron.com/KB/a143/cross-chart-axis-at-specified-value-or-percent-in-ssrs.aspx I hope this helps. Einar

Hi Challen, I am not able to see the "Cross At" drop down once I select the Horizontal Axis (X Axis) properties. The only options that I can see under Axis options are a) Side Margins b) Interval c) Interval Type. Same is the case with the Vertical Axis properties (Y axis). The options that I can see are a) Minimum b) Maximum c) Interval d) Interval Type FYI I opened the rdl in code (i.e the XML format and there found the "Cross At" option but still it did not work. Thanks in advance, Suman

Hi Suman, Are you sure you are using SSRS 2008 just as you mentioned in your first post? If so, you will see below dialogbox after you opening the Axis property. If you does not see this feature due to some expected issue, you could open your report in XML document, then find out CrossAt node, then type in <CrossAt>=Cint(0)</CrossAt> Then you will see what you want. Thanks, Challen FuChallen Fu [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 Suman, Are you sure you are using SSRS 2008 just as you mentioned in your first post? If so, you will see below dialogbox after you opening the Axis property. If you does not see this feature due to some expected issue, you could open your report in XML document, then find out CrossAt node, then type in <CrossAt>=Cint(0)</CrossAt> Then you will see what you want. Thanks, Challen FuChallen Fu [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 Challen, I am using SSRS 2008 R2 version. I know that as per the screenshot you have provided the Cross - At option should be visible, but somehow it's not. In my earlier post I had said that I tried to open the RDL in XML and then modify but that it didn't work. Over the weekend I was able to resolve the issue in XML itself. It seems that there are 2 "<CrossAt> </CrossAt>" attributes per axes, so in total 4 of them. I set all of them as <CrossAt>0</CrossAt>. This resolved the issue. P.S.- Should I be using <CrossAt>=Cint(0)</CrossAt> in place of <CrossAt>0</CrossAt> ? Thanks, ~Suman