Automatic chart creation

  • Hello guys,


    I need to make code for automatic creating of chart, which has to look like the one in the workbook.


    The number of columns won't be same. Sometimes 30 columns and sometimes 50 columns and so on.
    The number of rows will be from 100 to "infinite".


    I also need to be able to choose which columns should appear in final chart.
    Y axes will always be column "A"


    The final chart should be created in to new workbook.
    I added sample book with final chart, that I need.


    Any help you can offer would be hugely appreciated.[
    ATTACH]73855[/ATTACH]