Dynamic Charts VBA Excel For Loop even odd columns help

Hi everyone,

Can someone please help me with the below code?

I am quite new to VBA and I managed to find a code that solves my problem however there's a bit of error that I am not able to fix. Please see the code below:

Please Login or Register  to view this content.

Basically, the macro needs to loop through the columns and create charts based on the columns even or odd state. For example: Chart1 and Answer 1 should be one chart, Chart2 and Answer2 should be the next one and so on.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Try this variation.

Please Login or Register  to view this content.

Done. Could someone please help?

Did the code I posted not work? If so what error, if any, did it report?

Thank you so very much Andy! Yes it works.

Hi Andy,

Thanks for all your help so far. Meanwhile, I have tweaked the code a bit to suit my needs. Like now when we click on the macro button it creates a new workbook with the charts on it.

Please Login or Register  to view this content.

However, my question is whether we could copy the data as well? I mean for each chart the chart selection data should also be shown in the background. Will attach a sample for your reference. Hope this makes sense. Thank you