customize the y-axis interval using Expression in SSRS
HI is there any way we can customize the interval of Y axis using an expression , i had my chart with data (numbers) from 3-4 like 3.1,3.3,3.4,4.0 when i plot it the interval is starting from 0 and ending at 4 and the plot looks very tiny to observer and it is not looking good ,is there a way i can get the interval starting from 3 and ends with 4 so i can plot it i mean the interval has to start with min value of my data and has to end with max value, can any one help me out with some idea and refrence links thansk in advance
March 30th, 2011 4:17pm

It is possible to set the minimum and maximum values of the Y axis based on data values in the chart. For example, if we have 2 data fields “Category” and “Amount” in the dataset, and specify the “Category” as the Category Group of the chart and specify the “Amount” as data value of the chart. In order to control the minimum and maximum values of the Y axis dynamically, please refer to the steps below: 1. Select the Y axis. 2. In the properties pane: Specify the Maximum property to the expression like =Max(Fields!Amount.Value,"Chart1_CategoryGroup") Specify the Minimum property to the expression like =Min(Fields!Amount.Value,"Chart1_CategoryGroup") Please also be aware to correct the field and group names in the expression based on your report. 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.
Free Windows Admin Tool Kit Click here and download it now
March 30th, 2011 11:17pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics