CorporateCharts can be used to add (and remove) secondary axes in a chart. This is only supported in Excel.
Module is located here:
...\ModuleLibrary\CorporateCharts\01c_nocontext_Specific Chart Elements
CMD to add a second axis
<Cmd case="CorporateCharts:addSecondAxis" axis="xxx"/>
Define whether the second axis should be added to the
y axis or
Define to be
true to allowing a second axis to be added if it was added prior.
Optional. Define to be
true so it leaves area between plotarea and legend.
CMD to add an axis for negative values
When a graph contains negative values, it is beneficial to move the X-axis to be placed below the values. Use this command to do so.
<Cmd case="CorporateCharts:x-axis-negative-values" />
CMD to remove a second Y-axis