1 of 1 people found this helpful
Can you attach a sample of your data structure please, preferably as a packaged workbook - Packaged workbooks: when, why, how
I think you could probably do this if you structured your data so it was 'deep' (longer file) rather than wide like it is now.
I'd make it more generic like;
Metric, X Value, Y Value
Then your 'Metric' could be a dropdown filter which you swap between to make it dynamic.
Attach a sample and I'll see if I can't get it working.
Thank you for your help.
Following your suggestion, I was able to 'unpivot' the data and it is now much easier to apply my visualization to any and all columns in the original data.