Dual values in Column chart Y axis in SSRS 2008

Question

Hi,

 Any one pls tell me how to show dual values in Column chart Y axis.

Example:

Im showing Total Number of clients in the Y axis of column chart

My Requirement is

In that Y axis column chart also  i want to show differently of Inactive clients from total number of clients.

how to do this pls help me.

Thanks in advance.

TotalnumberOf clients :  1000

InActive Clients : 200 among TotalnumberofClients

 

 

 

Answer 1

You can add a second data series field which will display two groups of values along each X-axis (category) group value.  The specific visualization depends on the chart type.  If you want the two axis values plotted on different axis scales, in SSRS 2008 or R2, you can change one of the series to the secondary axis.  For a column or line chart, this will show the primary axis scale on the left and the secondary axis scale on the right side.

---

Paul Turley, MVP [Hitachi Consulting] SQLServerBIBlog.com

Answer 2

We are using SSRS (2008 R2).

Our dataset has multiple filters & 1 X axis, and 2 Y axis type data. The Y Axis data is related and are to be shown as stacked bar.

This is easily doable in Business Objects, and our effort is to discontinue it and move to MS. However, while in Excel I can implement this, SSRS developers from my team can not implement this.

I have searched and found that it was expected to be implemented in SSRS 2008 R2, but could not find how this can be implemented. Can someone please help? I am not being allowed to attach an image, else I'd have. Basically, how can we implement multiple Y-axis data in SSRS 2008 R2?