Creating a new chart with code


Jeff Ciaccio

Does anybody know how to create a chart on a userform? I'd like to set up a
tab for changing the initial parameters and then another to view a couple of
charts based on those initial conditions.

If not on a user form, what is the code to create a new x-y chart and place
it in a given range in a given sheet? What parameters can it take to format
the chart (type, data series range, scaling, chart area/background, etc)?


- Jeff (VBA neophyte)

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question