Post reply

Force the axes to increment in whole numbers only

  • December 27, 2012 at 3:09 am

    #286800

    I have a chart where the y-axis represents a number which will only ever be whole numbers. If, when the report is run, the maxiumum value happens to be a low number such as 2, then the y-axis increments in steps of 0.5. I've attached an example.

    Is there a way to force the axes to increment in whole numbers only?

  • January 3, 2013 at 7:34 am

    #1573323

    There's an Interval option on the Axis Options page of the Axis properties.

  • January 6, 2013 at 11:36 pm

    #1574172

    I cannot set the interval because for one parameter selection the data is between 0 to 2 and for the other it is between 0 to 1000.

    Is there any other way to achieve whole number interval in the axis?

  • January 7, 2013 at 3:37 am

    #1574237

    You can use an expression to give different values for the interval based on the parameter value:

    =iif(Parameters!Parm1.Value = 10, 1, 50)

    (if the parameter's value is 10, this sets the interval to 1, otherwise the interval is 50).

    Is that any good to you?

    Cheers

    Gaz

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply