I am a light user of Excel but moderately competent with computers! I am using Windows 10 with Excel 2016.



I have created a line chart with values showing on the left hand vertical axis and dates along the bottom horizontal axis. I have been struggling with trying to add a second series of values to the same chart. The second range of values are different to the first series so I would like to show these on the right hand axis while using the same dates of the horizontal axis.

How do I achieve this? The 'Help' pages have confused me more than helped, possibly because I don't know the 'language' and, therefore, I am probably asking the wrong questions.

To regular Excel users this should be a 'walk in the park' but has me stumped! Any help/advice gratefully received