Friday, 17 December 2010

Secondary Axis in SSRS Chart

Secondary Axis Chart
From SSRS 2008 we have Secondary Axis option, ie we can have two measures on two different axis
To do so on your normal chart Drop another Measure/ Numeric Field in “Data Filed” of chart.
Just like following



Then Right click on the second data filed , click on change cart type and then select line chart.
Result will be something like following


After that right click on 2nd data filed which you made it line chart and go to the series property
è On property window Now go to” Axes and chart Area tab”  à select value axis as a secondary


Press ok and preview your chart.
Now you have two axis in one chart for different data filed like following





2 comments:

  1. This post is probably where I got the most useful information for my research. Thanks for posting, maybe we can see more on this.
    Are you aware of any other websites on this
    msbi


    ReplyDelete