Ok this was annoying to figure out thus i had to share this out.
I was trying to create 2 y axis graph, or chart, in Excel since the scale of the 2 data sources was not easy to put in one graph, one was in the tens and the other was in the thousands, i had to work a little harder.
First step is to create a graph using your data and select the type of graph you would like. in our case i went with dual line graph.
Next step was to change the scale so right click on the smaller line chart, the blue one in my case, and select the “Format Data Series…”
Then you get a popup window for the series with an option to change the series axis to “Secondary Axis”, choose that!
When select the Secondary axis option and close the window using the Close button the graph will update and a new series will appear on the graph..
Wasnt too hard now was it?
P.S. the process can be repeated for more lines and more Y axis but i am not sure how useful that data will be.