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
This post is probably where I got the most useful information for my research. Thanks for posting, maybe we can see more on this.
ReplyDeleteAre you aware of any other websites on this
msbi
Good information. Thanks for posting.
ReplyDeleteSAP successfactors online training