I am trying to copy a template with a chart which has sheet scoped Named Ranges.
Problem 1: When the (template) sheet is copied, the Named Ranges are created/present for the new sheet ... but the series ranges for the chart are hard coded. That is, they do not use the sheet scoped Named Ranges in the copy of the chart on the new sheet. Tried and failed to work my way around that.
Problem 2: I thought I'd just set up the SeriesCollection formulae based on the Template worksheet/chart. But I seem to be struggling with that too
I've checked the basics and the sheet, chart, etc., are all as expected. And, if I use the hard coded values, it happily accepts it. However, when I try to set the SeriesCollection formula with Named Ranges, I get an error.
Whereas, this works:
I'm using this to test the theory:
Am I missing something? Well, I guess I must be, but what?
Any thoughts, advice, comments, alternative approaches welcome.