Loop Rows of Data and Create Graphs

I have data on one sheet:
Day Day Day Day Day
Store #
Store #
Store #

I would like to create a graph for a specific time period (7 days) for each store on a new sheet. This is what I have so far:

Please Login or Register  to view this content.

I know something is wrong with my loop statement and I can't figure out how to make it create a new sheet for each graph. Forgive me, I'm a newbie to VBA.

Any help is greatly appreciated. Thanks, in advance!

Cindy

Hi

Why do you need to create a new graph for each item? Why not create one graph, and have a selection process that allows you to select each store and have the graph update for the selected store?


rylo