Need a chart on a SQL Server Reporting Services chart with a secondary axes.
Need measure #2 on a secondary axes:
1. In the Design Mode > Open the Chart Date Pane > For Measure #2, navigate to Series properties:
4. Make sure to rename the axis title of the secondary axis, format the number to make it consistent with the report layout.
SSRS Version needed: SQL Server 2008 and above.
In this post, you saw how to add a secondary axis on a SSRS Chart.