In SSRS 2008 i have a chart with multiple chart type(column, line and range). The chart has only a primary axis the the y-axis values being in hours. What I need is in addition to the hours I would like to represent an equivalent number of days on the right side of the chart. I know that I can multiply one of my series by 24 and associate it with a secondary axis but I need the maximum axis range to be set to auto at the same time I need the primary and secondary to be proportional and that is where I'm stuck. Thanks in advance.

Hi Tom, In order to make the primary and secondary vertical axes proportional, one workaround is to specify expression to the minimum and maximum values of them. For example, if there is a data field Hours in the Chart, the primary vertical axis is for hours and the secondary one is for days, then we configure the vertical axes by the following setting: Minimum Maximum Interval Primary 0 =Max(Fields!Hour.Value) 12 Secondary 0 =Max(Fields!Hour.Value)/24 0.5 After that, the primary and secondary axes are proportional. 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.

This is what I've tried doing but I can't figure out the correct expression because the chart is a stacked column chart I'm thinking the =Max(Sum(Fields!Hour.Value)) but it doesn't like that.

This is what I've tried doing but I can't figure out the correct expression because the chart is a stacked column chart I'm thinking the =Max(Sum(Fields!Hour.Value)) but it doesn't like that.