none
y axis scale issue in chart RRS feed

  • Question

  • i have created a chart and it displays the y axis scale in millions, when the same chart has the vales just in thousand the scales does not display, is there any intelligent way that the chart will show inthousand if there is no values in millions.

    Wednesday, October 1, 2008 6:02 AM

Answers

  • Chart does not have a feature which allows you to that automatically, but you can determine the maximum data range in the expression and set axis settings based on the range the maximum value falls in. Usually you need to set axis title and labels formatting string.

    Alex.

     

    Wednesday, October 1, 2008 10:06 PM
    Moderator

All replies

  • Chart does not have a feature which allows you to that automatically, but you can determine the maximum data range in the expression and set axis settings based on the range the maximum value falls in. Usually you need to set axis title and labels formatting string.

    Alex.

     

    Wednesday, October 1, 2008 10:06 PM
    Moderator
  • Hi Alex,

    Can you please let me know how to do this?

    Thanks,
    Manoj Deshpande.
    Tuesday, June 9, 2009 10:08 AM
  • Hi Manoj,

    just go to the axis properties window - Axis Options. The property you need to set is called Maximum and is under Set axis scale and style.
    You can also use the interval option (just below the scale) .

    Hope this helps.

    Maria
    Tuesday, June 9, 2009 11:46 AM
  • Thank Maria.

    However, I use the same chart to display multiple data (in different executions though). So, the percentage CPU usage might have a max of "100", but the Physical Disk Read would be even less than 1, sometimes. How can we manage  this scenario?

    Thanks,
    Manoj Deshpande.

    Tuesday, June 9, 2009 12:14 PM
  • Hi again,

    I can think of two options:

    1. Use the expression in the Maximum property
    2. Or you can add a second category field - actually it is the same that you have alerady added but you need to format its labels differently so this will actually simulate what you aim to achieve.

    Maria

    Tuesday, June 9, 2009 12:18 PM
  • If you are trying to graph two different units on the same y-axis, the best thing to do is examine the maximum and minimum values of each the fields and then choose which set of units you will use for the y-axis.  Once you have this,   you will then need to compensate for this on your data fields by multiplying or dividing the values by some factor (10x, 100x, 1000x, etc.). If you are using SSRS 2008, you can then set the Axis Title  or Chart Title to an expression which you could use to denote the unit type for each of hte values to the user.  If it's 2005, you will probalby need to place a textbox on top or to the side of the chart that contains that information.

    -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
    Tuesday, June 9, 2009 4:40 PM
  • Hi Sean,

    Thanks, but that wasn't quite clear. Can you please explain more?

    Now, what I have done it, kept the min value to 0, and set the maximum value to be the Maximum value returned in the data set. So, for Physical Disk, if the maximum value returned in the data set is 3, the length on the Y-axis will be that much.

    I was still curious, do we have an option of adding a drop down option in the report itself for the scales - which the user can select when he chooses the other parameters? Example, for Processor usage, he might want to select the scale range to be "0-100" (showing the percentage), or for Physical Disk he might want to select "0-1.5" -- I understand that what I have done now (to the min and max properties) serves the same purpose, but I still want to know if this option can be given to the user.

    Thanks a lot,
    Manoj Deshpande.

    Monday, June 15, 2009 12:04 PM
  • Sure, you need to create a parameter in the report that will allow the user to choose the scale.  You can then reference that parameter that defines the scale when defining the various properties on the chart.  For example, if the users says show the units in 1000's you might want to divide a number in the dataset that is returned as 5,000 by 1000 so you would just references the Parameter in the same place where you are using the Min and Max fucntions for the Y-Axis properties.

    -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
    Monday, June 15, 2009 9:36 PM
  • Hi all,

    I have a problem scaling the y axis. I have a value axis and secondary axis and trying to compare two data. Now the thing I want the same scale for both the axis.

    Right now since its auto it cannot compare.

    Can anybody suggest how can I make both the axis with same scale. Tried even using the maximum value for the axis same but i have parameters that vary quite more.

    Help

    Friday, August 20, 2010 1:05 AM
  • You should be able to set the maximum and minimum value on each axis using an expression.  

     

    -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
    Saturday, August 21, 2010 1:32 AM