Generate multiple charts from cols B & C, conditional of duplicate data in col A

Hello!

I'm looking to create a VBA macro that would allow me to generate multiple charts from an array of data.

The data is setup as follows:

Please Login or Register  to view this content.

....etc... the list goes on and on.

I'd like to be able to write code that can create a chart, using Col C as the source data and Col B as the x axis label series, for each set of questions listed (as indicated by Col A, so 1.1.1 would be one chart, 1.1.1.1 would be another, etc.).

First - is this the best way of going about generating many charts quickly? Should I arrange the data differently?

Second - if so, how should the VBA code be written to distinguish between questions? That's where I'm stuck right now, and have no idea where to start.

In the end, I'd like to output charts, like the one below:

chart example.JPG

Any help would be greatly appreciated! TIA.

Assuming that the data starts at Row 2, and that the charts are to be created and placed on the same worksheet as the data, one on top of another at Column E, try...

Please Login or Register  to view this content.