Re: WaferMap

Hi All,

Here is what i am looking.

I have a excel sheet with three Columns.X value,Y value and third columns called BIN.
I shall show u a sample values as below.

X     Y    BIN
4     3      1
7     5      4
8     2      3
7     1      1
3     5      6
2     6      4
1     3      9

When i tried to plot graph manually by recording Macro here is what i get.

Sub Plot()
    Range("B3:C10").Select
    ActiveSheet.Shapes.AddChart.Select
    ActiveChart.SetSourceData Source:=Range("'Sheet1'!$B$3:$C$10")
    ActiveChart.ChartType = xlXYScatter
End Sub

But actually is it possible to plot the points in a EXCEL sheet rather than on a chart.
I have attached a .xls file.That looks similar to what i want to achieve.Its called the wafer Map.

Its just plotting the X and Y points with corresponding BIN number recorded in that point.And as the Range of X and Y axis varies each file its better to have it dynamic as per MAX value of X and Y axis.

I hope u can understand once u have a look into this Excel file.

Thanx