Thanks Jeffrey. I've tried to make sense from the links you kindly supplied, one is from pre-2016 Excel and with the other I cannot follow the steps as I can't find exactly what it refers to as it goes through the various steps. Perhaps I'm not as computer literate as I thought!!

As another way of posing my question I have attached the file I am trying to amend. It is a file for logging my Blood/Sugar Tests as I am diabetic. As you will see, I show the various blood tests without problem against the date axis. I would like to include 'Weight' as well as it will be interesting to see if the diet I am now applying has a direct effect in lowering my Blood/Glucose readings. A visual rendition of my progress on a chart my well help me keep to my regime!

I have been trying to create a second axis on the right of the chart using data from the 'Weight' column probably set between 99 and 106 and showing in column format.

Any other ideas? I have attached the file in question although as I look at this post I can't see any evidence of it being attached, so, fingers crossed.

Attached Files

Blood-Glucose Test.xlsx (403.2 KB, 9 views)