I have 3 columns of data: "Type", "Sales", "GM%".

I would like to create a series of scatters (one for each value of
"Type") with "Sales" on the x axis and GM% on the y axis. In the past
when I've had to do this, I've sorted by "type" then manually selected
the appropriate cells. But this time I have 40k rows with 35
different values of "Type". Furthermore, each chart will have two
different series ("Types") that will be differentiated by color.
Doing it by hand will take hours and hours - and the data is likely to
change later.

So is there a way to programatically select and color data series in
Excel 2007?