I do this for products 1 through 7, then repeat for Sales Actual vs Sales Prior Year and Sales Actual vs Sales Last Period, which gives me a 3x7 matrix of traffic lights. Is there any way that I can type this expression once then clone the graphs and simply mass-edit all of the graphs on the second line to change "Actual" to "Plan" without going in individually and changes each one? This would save me so much time!
What about, for the same graphs, is it possible to select all of them and change their ranges all at once rather than going in, individually, and changing each one?
I mean, I want to clone an object and when I paste it, I want it to be in a different location than the original (when you clone, it's slightly offset, whereas a copy-paste is in the exact same spot), but not everything seems to have Clone as an option, just Copy.