chart into new workbook

[Weil]

Hi,

I am creating a chart in VBA, but I would like the chart location to be a sheet in a new workbook. How do I do this?


I love this site and have found it very helpful, but I've searched the posts for this particular item and haven't found anything yet that I can use...

Thanks for the help!

 

[Weil]

Hi, I did not receive any replies to this, so I thought I would alter my request -

what I need to do is create a handful of charts with macros (potentially, more than a handful).

I'd like to avoid creating a worksheet for each chart, rather it would be nice to have every chart in one particular whorksheet ("Charts")

any help is appreciated!!