I have put together a dual axis that uses a dynamic label.
However I can only add a label to the Y axis on the left. I’m unable to add a Y axis on the right hand side. I was then able to create a separate sheet and display the label on its own and align it with the chart. Not great but it does the job.
Is there a better way to add a dynamic label to the right hand side?
Finally I am also unable to synchronize the axis as it’s greyed out, they are the same data types so it shouldn’t be a problem.