Excel pivot chart change bar color based on value

The treemap changes to show a uniquely colored rectangle for each Sub-Category: The two fields on Color ( Category and Sub-Category) are related within a hierarchy, so if you swap their positions on the Marks card, moving Sub-Category to be above Category, the effect is the same as if you had removed Category from the view altogether. The size of the individual rectangles is still determined by Sales, per Category and Sub-Category. Tableau uses distinct, categorical colors for the first field, Category, and a range of sequential shades to distinguish values for the second field, Sub-Category: The marks are still sized by the sum of Sales, but now they are colored by Category:Д¬lick the label icon to the left of Sub-Category on the Marks card and select Color. Tableau moves all fields to the Marks card, putting SUM(Sales) on both Size and Color, and Category and Sub-Category on Label:Д¬lick the label icon to the left of Category on the Marks card and select Color:Д¬ategory replaces SUM(Sales) on Color. You can use one field to set the hue, and the other to show gradations within that hue.ДЇollow these steps, using the Sample - Superstore data source, to build a treemap with two fields on Color.Дrag Category and Sub-Category to Columns.Д¬lick Show Me in the toolbar, then select the Treemap chart type. However, depending on the chart type, for example treemaps and bullet graphs, you can put multiple fields on color. If you drop one field on Color and then drop a different field on Color, the second field replaces the first field.

Excel pivot chart change bar color based on value