Attempting Scatter Diagram

[SpanishSahara]

Hi guys I'm having some serious Excel graph trouble thats driving me nuts. Basically I have two sets of data results for a set of 18 companies, (I've rated them on a serious of criteria and come up with these final numbers) and would like to plot both numbers on a scatter diagram with one point for each company. I'll try and explain a bit better in the screenshot below:

\1

So for the e xample company OSC, they score 19 on stage one and 14 on stage two, so the companys symbol ends where these points meet.

Any help would be great thanks.

[teylyn]

1. Welcome to the forum
2. If you want help with Excel, post Excel workbooks, not pictures
3. Upload your files to the forum, not to untrusted external sites.

cheers,

[SpanishSahara]

OK, thanks, uploading with this post.

Hope you're not saying my artistic paint drawing is inadequate?!

[Andy Pope]

You need to use the Select Data dialog to define the correct ranges for the Series Name, X value and Y value.