How to create chart basic

[Guest]

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

 

[Guest]

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

 

[Jon Peltier]

It makes no sense to use Lot as Y values. Looks like Location makes a good X
value, value a good Y value, and Lot makes a good series name. At least it
makes sense given the small description you've provided.

First set up the data properly. Put X in the first column, and each series'
Y into subsequent columns, like this:

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

The top left cell of this table is blank. Select the table, including the
Lot names and location numbers, and create an XY chart or a line chart.
Format as desired.

- Jon