lowai
07-08-2008, 06:15 PM
Dear experts,
I am new to VBA. I have a problem base on creating chatrs. I have attached a sample of my data (but just a part of it, I have quite a number of samples).
The basic operation is to create a XY scatter ploted by columns with the selected data. In the sample, it shows 3 categories. For each category, plot a xy scatter. It will generate a single plot base on the same category in a new worksheet.
E.G. for category "AA01", the plot should have 4 points. And for category "BP12", it should have 6 points.
Just want to know any of you expert can help.
Regards,
Lowai
I am new to VBA. I have a problem base on creating chatrs. I have attached a sample of my data (but just a part of it, I have quite a number of samples).
The basic operation is to create a XY scatter ploted by columns with the selected data. In the sample, it shows 3 categories. For each category, plot a xy scatter. It will generate a single plot base on the same category in a new worksheet.
E.G. for category "AA01", the plot should have 4 points. And for category "BP12", it should have 6 points.
Just want to know any of you expert can help.
Regards,
Lowai