Hi,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I'm using Excel 2010 and i've just recorded a macro via the developer tab to create a chart. I need to add functionality to it to create a new chart for each row in the spreadsheet that has data in it (if this is not possible if I could set it to go down a set number of columns that would be fine). <o></o>
I assume a for loop is the key to doing this but I have no idea how to implement this in VBA.
<o></o>
Here is a screenshot of the data layout I have and an example chart<o></o>
https://mmhs.co.uk/index.phtml?d=149488
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I'm using Excel 2010 and i've just recorded a macro via the developer tab to create a chart. I need to add functionality to it to create a new chart for each row in the spreadsheet that has data in it (if this is not possible if I could set it to go down a set number of columns that would be fine). <o></o>
I assume a for loop is the key to doing this but I have no idea how to implement this in VBA.
<o></o>
Here is a screenshot of the data layout I have and an example chart<o></o>
https://mmhs.co.uk/index.phtml?d=149488