Plot Data on a Secondary Axis (Report Builder and SSRS)
The chart has two axis types: primary and secondary. The secondary axis is useful when comparing two value sets with two distinct data ranges that share a common category.
For example, suppose you have a chart that calculates Revenue vs. Tax for the year 2008. In this case, the 2008 time period is common to both value sets. However, when both series are plotted on the same y-axis, we cannot make a useful comparison because the scale of the y-axis is optimized for the largest values in the dataset. If we show Revenue on the primary axis, and Tax on the secondary axis, we can display each series on its own y-axis with its own scale of values. The series still share a common x-axis.
In situations where there are more than two series to be compared, consider a different approach for comparing and displaying multiple series in a chart. For more information, see Multiple Series on a Chart (Report Builder and SSRS).
An example of this chart is available as a sample report. For more information about downloading this sample report and others, see SQL Server 2012 Report Builder and Report Designer sample reports.
You can create and modify report definitions (.rdl) in Report Builder and in Report Designer in SQL Server Data Tools. Each authoring environment provides different ways to create, open, and save reports and related items. For more information, see Designing Reports in Report Designer and Report Builder (SSRS) on the Web at microsoft.com.
To plot a series on the secondary axis
Right-click the series in the chart or right-click on a field in the Values area that you want to display on the secondary axis and click Series Properties. The Series Properties dialog box appears.
Click Axes and Chart Area, and select which of the secondary axes you want to enable, the value axis or the category axis.