Plotting Question

[ImbadatExcel]

Hello,

I have a plotting question that may have a simple answer. I have a column of dates and another column of part numbers. When I try and plot this data (with the date on the x-axis, and the part numbers on the y-axis) I cannot get an accurate scatter plot (it seems like excel is not recognizing the part numbers are different values).

As a note, there are only two different part numbers but all the dates are different.

I hear that I can assign numerical values to these part numbers so that excel will plot the numerical values in place of the part numbers, but I am not sure how to do this (something to do with a legend?). I put the data I'm using below. I would appreciate any help that you would be able to give. Thank you!

Have a great day!

3/2/2006	1277M91G07
4/10/2006	1277M91G07
3/21/2006	1277M91G08
3/21/2006	1277M91G07
4/10/2006	1277M91G08
3/2/2006	1277M91G08
3/21/2006	1277M91G08
3/21/2006	1277M91G07
3/6/2006	1277M91G08
2/21/2006	1277M91G07
2/21/2006	1277M91G08
3/6/2006	1277M91G07
5/1/2006	1277M91G08
5/1/2006	1277M91G07
4/27/2006	1277M91G08
4/27/2006	1277M91G07
4/26/2006	1277M91G08
4/26/2006	1277M91G08
4/26/2006	1277M91G07
4/26/2006	1277M91G07
4/25/2006	1277M91G07
4/25/2006	1277M91G07
4/25/2006	1277M91G08
4/25/2006	1277M91G08
4/21/2006	1277M91G08
4/21/2006	1277M91G07
4/20/2006	1277M91G07
4/20/2006	1277M91G08
4/6/2006	1277M91G08
4/6/2006	1277M91G08
4/6/2006	1277M91G07
4/6/2006	1277M91G07
3/29/2006	1277M91G07
3/29/2006	1277M91G08
3/22/2006	1277M91G07
3/22/2006	1277M91G08
3/21/2006	1277M91G07
3/21/2006	1277M91G08
3/21/2006	1277M91G07
3/21/2006	1277M91G08
3/21/2006	1277M91G07
3/21/2006	1277M91G08
3/15/2006	1277M91G07
3/15/2006	1277M91G08
11/22/2005	1277M91G08
11/22/2005	1277M91G07
1/10/2006	1277M91G07
1/10/2006	1277M91G08
4/14/2006	1277M91G08
4/14/2006	1277M91G07
4/21/2006	1277M91G08
4/21/2006	1277M91G07
4/21/2006	1277M91G08
4/21/2006	1277M91G07
4/16/2006	1277M91G07
4/16/2006	1277M91G08
4/3/2006	1277M91G08
4/3/2006	1277M91G07
3/13/2006	1277M91G08
3/13/2006	1277M91G07
2/6/2006	1277M91G07
2/6/2006	1277M91G08
11/21/2005	1277M91G07
11/21/2005	1277M91G08
11/21/2005	1277M91G07
11/21/2005	1277M91G08
11/1/2005	1277M91G07
11/1/2005	1277M91G08
10/25/2005	1277M91G08
10/25/2005	1277M91G07
7/18/2005	1277M91G07
7/18/2005	1277M91G08
7/14/2005	1277M91G07
7/14/2005	1277M91G08
6/5/2001	1277M91G03
6/5/2001	1277M91G04
6/4/2001	1277M91G04
6/4/2001	1277M91G03
10/15/2005	1277M91G07
5/30/2006	1277M91G07
11/10/2004	1277M91G08
10/15/2005	1277M91G08
11/10/2004	1277M91G07
5/30/2006	1277M91G08

<colgroup><col><col></colgroup><tbody>
</tbody>

 

[oldbrewer]

make a list of unique partnumbers in one column and in the next column put 1,2,3, etc

name this table mytable

for EACH part number in the list with dates put in C col (say C2)

=vlookup(b2,mytable,2)

you may have to sort mytable in part number ascending order

 

[oldbrewer]

date	partnum
01/01/2015	1277M91G07	3
02/01/2015	1277M91G07	3		1277M91G03	1
03/01/2015	1277M91G08	4		1277M91G04	2
04/01/2015	1277M91G07	3		1277M91G07	3
05/01/2015	1277M91G08	4		1277M91G08	4
06/01/2015	1277M91G08	4
07/01/2015	1277M91G08	4
08/01/2015	1277M91G07	3
09/01/2015	1277M91G08	4
10/01/2015	1277M91G07	3
11/01/2015	1277M91G08	4
12/01/2015	1277M91G07	3
13/01/2015	1277M91G08	4
14/01/2015	1277M91G07	3
15/01/2015	1277M91G08	4
16/01/2015	1277M91G07	3
17/01/2015	1277M91G08	4
18/01/2015	1277M91G08	4
19/01/2015	1277M91G07	3
20/01/2015	1277M91G07	3
21/01/2015	1277M91G07	3
22/01/2015	1277M91G07	3
23/01/2015	1277M91G08
01/01/2015	1277M91G08
02/01/2015	1277M91G08

<colgroup><col><col><col span="2"><col><col span="2"></colgroup><tbody>
</tbody>

 

[Worf]

This page shows how to use the part numbers as axis labels: Custom Axis Labels and Gridlines in an Excel Chart - Peltier Tech Blog