Scatter Chart

[bluenose5709]

Good afternoon all,

I hope that my question is a simple one.

As you can see from the image below, I have a scatter chart focused currently upon two columns. Column F to depict age and Column I for the amount of time on Squad. What i would like would be a more granular spread on age, hence Column G showing age in Months, however, whilst I am content to use age in Months for a calculation I would like the scatter chart to show age in years as per the image below but to position the Blue dots correctly as per the Months.

Any help on this would be great
Thank you

 

[bluenose5709]

I should have persevered a little longer. I have sorted it by dividing the months in age by 12 and showing 1 decimal point. this now displays how i need.

thank you agnyway