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

Process</SPAN>	Level Of Change</SPAN>	Complexity</SPAN>
A</SPAN>	1	5
B </SPAN>	2	4
C</SPAN>	5	3
D</SPAN>	3	2
E</SPAN>	4	1

<TBODY>
</TBODY><COLGROUP><COL><COL><COL></COLGROUP>

 

[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