Two axis charts

[TG2812]

Hello,

I'm trying to get my head around doing a simple chart at first but it turns out to be a nightmare.

I want to create the chart in the first image i uploaded in Excel. My dataset is attached in the second picture.

Any help would be greatly appreciated!

PS: if you could provide your response using an excel sheet, this would be fantastic. Thank you!

 

[myall_blues]

Set the maximum value of the vertical axis to 11.
Note the instruction in my previous post.

“Right click on the secondary vertical axis, select format axis, and set the axis bounds to 0 and 20 (or whatever your highest model number is)”.

 

[TG2812]

Sorry, I have not read correctly. Thank you very much for your great help. It now works perfectly

 

[myall_blues]

You’re welcome. Glad it works for you.