none
SSRS 2008 line chart , how to put the vertical axis in the miidle of the chart? RRS feed

  • Question

  • Hi guys

    I have created a line chart in SSRS 2008 and just want to ask how can I put the vertical axis in the middle of the chat. My x axis go from negative to positive value, I want my vertical axis place in "0". Thanks!

    Thursday, January 6, 2011 5:53 AM

Answers

  • If I understand your question correctly, if you select the Axis and then display the property grid (which you have to turn on), then you should see a CrossAt property under the scale section.  You can set that to an expression that determines the middle point and that should work.

     

    -Sean


    Program Manager, SQL Server Reporting Services This posting is provided "AS IS" with no warranties, and confers no rights. http://blogs.msdn.com/seanboon http://www.twitter.com/ssrs
    • Proposed as answer by Tony ChainModerator Monday, January 10, 2011 5:31 AM
    • Marked as answer by ERIC350Z Tuesday, January 11, 2011 6:20 AM
    Thursday, January 6, 2011 7:43 AM

All replies

  • If I understand your question correctly, if you select the Axis and then display the property grid (which you have to turn on), then you should see a CrossAt property under the scale section.  You can set that to an expression that determines the middle point and that should work.

     

    -Sean


    Program Manager, SQL Server Reporting Services This posting is provided "AS IS" with no warranties, and confers no rights. http://blogs.msdn.com/seanboon http://www.twitter.com/ssrs
    • Proposed as answer by Tony ChainModerator Monday, January 10, 2011 5:31 AM
    • Marked as answer by ERIC350Z Tuesday, January 11, 2011 6:20 AM
    Thursday, January 6, 2011 7:43 AM
  • Thanks Sean!

    Its work!!

    Regards

    Eric

    Tuesday, January 11, 2011 6:20 AM
  • Hi all

    I've an issue related with this topic.

    After I do what Sean suggests the position of the labels of the horizontal line do not stay at the botton of the chart, they stay close to the horizontal line.

    How can I force the axis labels to be on botton?

    Best regards,

    TMF

    Thursday, May 23, 2013 7:10 PM