Process of enhancing bar charts with a two-color gradient, focusing on selecting and applying gradients to create a dynamic visual effect.
Method 1: Using measure names for discrete scale → Advantage: evenly colored bars
Method 2: Using measure values for continuous scale → Advantage: represent value distribution more accurately
I prefer using measure names to color a gradient bar chart because it ensures the gradient is applied evenly across the entire length of each bar. This method colors based on the bars themselves rather than their values, resulting in a proportional gradient regardless of the bar lengths. Measure values can cause shorter bars to display an incomplete gradient, making it difficult to see the full range of colors. But whichever floats your boat :)
Tableau: public.tableau.com/app/profil...
Excel: docs.google.com/spreadsheets/...