I'm trying to copy a chart that I've created, uniquely sized & formatted, but, even though I'm able to copy the chart, as soon as I change the data the formatting reverts back to default.

I've already tried saving the chart as a template and reloading it. This half works, the formatting stays the same but the size is completely wrong.

Is there any workaround here? I want to copy this chart several dozen times, to do so manually would take a long time and would inevitably introduce minor variances.

thanks