I’m looking to assign multiple series to a secondary axis. I have information in tonnes and tonnes per capita. I know to created the second axis and assign a series to it, however I can’t seem to assign multiple series to the second axis. Any ideas?
I’ve attached the graph in question for reference. I have to get the line series (per capita) onto the same secondary axis.
Thanks for your help! I’ve managed to get the series on the same axis.
HOwever now there is a secondary issue. The series on the graph will not align with the data.
Once assigned to the same axis, each graph simply stacks upon one another. The yellow lines data values are approximately 1.3 - 1.7. The pink and blue data data values are approximately 0.5 - 0.6.
Is there a way to have the data conform to axes constraints to appear in appropriate ranges?