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.
When i tried to plot graph manually by recording Macro here is what i get.
X Y BIN
4 3 1
7 5 4
8 2 3
7 1 1
3 5 6
2 6 4
1 3 9
But actually is it possible to plot the points in a EXCEL sheet rather than on a chart.
ActiveChart.ChartType = xlXYScatter
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.