Hi All,
I'm trying to display a data series as a heatmap, but one which changes the size of the boxes depending on the size of the data.
E.g.
Apples 25%
Pears 10%
Oranges 20%
Bananas 20%
Grapes 25%
So the above data, if each one was supposed to be 20%, then Apples/Grapes would be Yellow (as over 20%, but only just, say within 5% either way), Oranges/Bananas Green (as perfect) and Pears Red (as below, and more than +/1 5%).
But the sizes of the boxes should change size...based on 100% being the total of the data.
Similar to the attached.
Cheers
Paul
I'm trying to display a data series as a heatmap, but one which changes the size of the boxes depending on the size of the data.
E.g.
Apples 25%
Pears 10%
Oranges 20%
Bananas 20%
Grapes 25%
So the above data, if each one was supposed to be 20%, then Apples/Grapes would be Yellow (as over 20%, but only just, say within 5% either way), Oranges/Bananas Green (as perfect) and Pears Red (as below, and more than +/1 5%).
But the sizes of the boxes should change size...based on 100% being the total of the data.
Similar to the attached.
Cheers
Paul
Last edited: