SW, just looking for posts with no replies and spotted this one. Did you get sorted?
I have used Rhys framework series as a basis for my code to standardise the size, format and colours of my trends (very handy once I got it working!) and it may suit your task.
An alternative would be to build two seperate workbooks and toggle between the two.
All the best,
miles
MilesUK
ProcessBook v3.0.15.3