Auto generating Charts

[kBarnes]

I have 5 columns of data: Subject ID, Individual Score, Overall Average, Male Average, and Female Average; with 850 rows of data. I want to auto generate a new graph per row.

I found this macro code

Please Login or Register  to view this content.

Which works nicely, except that I do not want Column A to be generated as a bar in the graph, I want it only as the chart title.

Can anyone help?

Moderator's Edit: Use code tags when you post code. To do so, select your code and click on the # icon above.