Create macro from existing chart

[NOYB]

Have several charts I would like to have a macro for creating.

The use case is a macro that downloads a set of data into an empty spreadsheet. Populates some cells with formulas and applies formatting.

At this point would like the macro to create these several charts.

Have seen some macros to create a simple chart but nothing that gets into the formatting that a person would typically apply to a chart. Such as axis label format, category and data series, legend placement, etc.

Is there a way to export a chart’s parameters for use in a macro? Or even better export a chart as a macro sub?

If not, can you point me to a real good chart macro example that goes beyond just creating a default chart?

Here’s a formatted chart example of what I’m looking to create from macro.

[Lupp]

The only reasonable way to do something of the kind is (imo) to provide oneself with chart templates.
To copy such a template from its nursery and to plant it where wanted is simple enough doing it interactively, but can also be done by user code.
The next step is then to adapt the ranges. If you study the (for you) relevant examples of charts thoroughly (in the Basic IDE, e.g.) you may succeed.