I am trying to create a scatter graph but cant seem to get excel to help me out!
I want the axes to be like the chart on the left, but with the data labels to show the group names (eg a, b, c, etc). Trouble is, when I select the group names, the chart ends up looking like the chart on the right, so they are somehow plotted as an additional series.
What I am after is something that looks like this (I did this one manually by using text box):
Any ideas?????
I want the axes to be like the chart on the left, but with the data labels to show the group names (eg a, b, c, etc). Trouble is, when I select the group names, the chart ends up looking like the chart on the right, so they are somehow plotted as an additional series.

What I am after is something that looks like this (I did this one manually by using text box):

Any ideas?????
Last edited: