How to create chart basic

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

0
Daniel1 (174)
6/28/2007 11:28:04 PM
excel.charting 18370 articles. 0 followers. Follow

2 Replies
893 Views

Similar Articles

[PageSpeed] 13

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
> 
0
FloMM2 (102)
6/29/2007 9:48:02 AM
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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______



"Daniel" <Daniel@discussions.microsoft.com> wrote in message 
news:093D418F-90FA-49EE-9428-3C873B386E60@microsoft.com...
>
> 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
> 


0
jonxlmvpNO (4558)
6/30/2007 1:59:10 PM
Reply:

Similar Artilces: