Macro to create chart for each row

[agentone]

I am working with Excel 2007, I have a spreadsheet that has a number of rows. Each row has a different title, x-axis and y-axis values. For each row I want to use a macro to create an identical chart,as the number of rows is likely to change.

I have attached an example spreadsheet. The chart titles are in column B, x-axis values are in Columns C to J and the y-axis values are in Columns L to S. An example chart is included.

When the charts are created i dont want them to appear on top of each other. I want them to appear beside each other.

[rylo]

Hi

Are you really sure you want to have many charts, or would a single chart that can be updated with the relevant data by making a single selection from a dropdown (or perhaps cycled by a macro) be suitable?

rylo

[agentone]

I would prefer to have many charts. Is this possible?