View Single Post
 
Old 04-23-2016, 06:33 AM
Don Harrison Don Harrison is offline Windows 10 Office 2016
Novice
 
Join Date: Apr 2016
Location: UK
Posts: 7
Don Harrison is on a distinguished road
Exclamation How to produce a second series in a line graph

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
Reply With Quote