Did more research and the CreateChart macro is what I have come up with so far. See new workbook.
If you look at the Test sheet, you will see the results are not usable yet, but it is a start. I need to code in the specific ranges for columns C, H, and I and the lables should hopefully change as well so the chart looks like the one on the Chart sheet.
I also need the macro to delete the current chart (if one is there) and replace it with an updated one. The chart also needs to automatically resize to accomodate the source data if possible.
So to sum it up, I need help to incorporate creating a new sheet from the Header sheet which is named by the user via an InputBox, and once the user is finished entering in the data in the new sheet, the macro would be run to create the chart using the sources starting in row 7 of columns C, H, and I.
Thanks,
Andrew
Bookmarks