Creating scatter graph

[Layo909]

In the attached screenshot, I am trying to create a graph to show how each population clusters. By selecting the data and pressing insert>scatter, excel has chosen population 1as the x axis and populations 2 and 3 as the y axis.

How can get all 3 populations on the y axis to show how they cluster?

[Andy Pope]

You will need to create a set of x values for each series assuming you want each data point within a population to occupy the same x point.