chart loop for multiple items found in a specific column

[brandon20]

Hi,


I see that this question has been asked alot, but none where really answering my question.
Im sure I was just not asking google in the correct way.


If anyone can point me in the right direction that would be great!


Problem:


I have a large table of data with multiple unique items (listed in column "B")


I need to make the same scatter plot for each individual item.(X values found in column "Y", Y values in column "T")


Ideally all the charts would show up on the same sheet, but not the data sheet.






This is the chart info for one item. I have an idea of how to go about this,
but not sure how to write code to create a scatter plot for each individual item(found in column B)


Series Name:
=DataSheet!$T$5


Series X values:
=DataSheet!$Y$6:$Y$38


Series Y values
=DataSheet!$T$6:$T$38






I guess what I would like to do is some sort of process of saying something like this.
Does B1=B2, yes, then include data in chart1, does B2=B3, yes, then include data in chart1.......
Does B30=B31, NO, Then Begin and include data in chart2........ and so on.
Just not sure how to write that.

Thanks for any help!