Plot Scatter Graph Excel 2010

[tomberns]

Hi everyone,

Hopefully someone can help...

I'm trying to set up a scatter graph using the data below and come up with 2 main issues:

1) The 'X' axis seems to double in number and plot random figures
2) I can't get the data labels to show the relavant 'A', 'B' etc


If anyone can help it would be much appreciated.

Thanks

Tom
[TABLE="width: 739"]
<TBODY>[TR]
[TD]Process</SPAN>[/TD]
[TD]Level Of Change</SPAN>[/TD]
[TD]Complexity</SPAN>[/TD]
[/TR]
[TR]
[TD]A</SPAN>[/TD]
[TD]1[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]B </SPAN>[/TD]
[TD]2[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]C</SPAN>[/TD]
[TD]5[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]D</SPAN>[/TD]
[TD]3[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]E</SPAN>[/TD]
[TD]4[/TD]
[TD]1[/TD]
[/TR]
</TBODY><COLGROUP><COL><COL><COL></COLGROUP>[/TABLE]

 

[pbornemeier]

Hard Way:
Define 5 series in the scatter plot. Series Name = Process; Series X values = Level of change; Series Y values = Complexity
Turn on labels for each series (point). Format labels to be = Series Name

Addin:
XY Chart Labeler