bluenose5709
Board Regular
- Joined
- Dec 15, 2012
- Messages
- 51
- Office Version
- 365
- 2024
- Platform
- Windows
- MacOS
- Web
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
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