It is a range of roughly 180 cells say A1:P19.
The data changes for each metric.
The first metric chosen returns 180 cells formatted as a number (no decimals).
The second metric chosen returns the same 180 cells this time formatted in currency.
The third metric chosen returns the same 180 cells this time formatted in time duration, and so on. If it was just 3 metrics then I could do 3 individual charts however there are over 30 metrics and I want to keep using the same charts. It's the time duration value that causes the problem.