Create several charts based on cell values

[rodrignj]

Hi, I am having trouble creating a macro that would be able to evaluate a column of cells and chart the corresponding x,y values. I need to do this for about 70 charts. In the column to be evaluated I have the name of my products: sodas, snacks, candy, and water; in the following columns, but in rows corresponding to the products I have the number of each purchased on a specific date. For example:

Column1 Column2 Column3
Sodas 10 1/1/2013
snacks 5 1/1/2013
candy 8 1/1/2013
water 15 1/1/2013
Sodas 7 1/3/2013
snacks 9 1/3/2013
candy 4 1/4/2013
water 11 1/5/2013
Sodas 12 1/6/2013
snacks 6 1/7/2013
candy 9 1/7/2013
water 20 1/8/2013

I need a macro that can seperate out each of my categories and chart the dates along the x and the amount purchased along the y. A final challenge to this is that i have the data seperated by quarter in different tabs but I want all the graphs to appear on a single tab, so it would also have to go to different sheets and find the data. Is this possible? I am usually ok at finding macros and editing them to suit my needs but this has been a different beast from anything I have ever tried to accomplish. Thank you very much for any help you can offer!

[arlu1201]

Is this solved?

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.

[rodrignj]

I found a macro at http://stackoverflow.com/questions/1...roups-and-crea that helped.