Daniel,
Highlight the whole chart of data.
Select the Chart Wizard on the top of Excel screen.
Select the scatter plot.
Data should be "rows" not "columns".
Select the "Series" tab.
"Name:" ="A"
"X Values:" =Sheet1!$B$2:$B$4
"Y Values:" =Sheet1!$C$2:$C$4

This assumes that your data is in column A thru C, Lot in A1, value in B1,
Location in C1.
A's,B's, C's and D's in column A2 thru A13, so on and so forth.

This will plot the data points, one color for A, another for B.......

Good luck,hth
:-)

"Daniel" wrote:


How to create a scatter chart with spread sheet below. The x axis may be
location and Y axis are lot name

Lot value location
A 3 1
A 4 2
A 5 3
B 6 1
B 4 2
B 2 3
C 5 1
C 6 2
C 8 3
D 4 1
D 9 2
D 5 3