How to Change the Colors in a Packed Bubble Chart in Tableau Using Measure Values

🆘 Need More Help? 📧 Email [email protected]

Subscribe: http://bit.ly/3i3WN4p How to Change the Colors in a Packed Bubble Chart in Tableau Using Measure Values

how do you change the colors of a bubble chart in this example I have a bubble chart using category and region with category on color and have a bubble chart where I have two different colors shades of blue for West and shades of orange for East let’s hop into a new sheet and show you how to do this in tableau
let’s start by building the bubble chart let’s grab some of sales and double click it region and category
and change it to a bubble chart by clicking show me and choosing packed bubble chart
now you can see the color is on category and region is on text there’s a bubble for each unique category in region the simplest way to change the color is going to be by dragging region while holding Ctrl and dragging it to color now instead of categories being driving the color the regions are driving the color the second example is more complex
what if you want to have two different Divergent colors let’s add a new sheet and do that let’s build the bubble chart one more time with sales region and categoryturn it into a bubble chart
this time since I want to shade them differently I want to write some if statements first I’m going to drag region to filters I only want to do a sample of this so I only want to use east and west
and let’s write a calculated field
it’s going to be that for the first color type
to call it Blues I’m going to type if region equals West then sales and
okay and let’s add a second one for oranges if region equals East then sales and
I’m going to bring both westa
actually going to bring West up to rows so I can bring in measure values so if I Drive West to rows I can drag East to the axis to give me measure values
and I can turn it back into a bubble chart by dragging measure values to size
measure names to details
you can see the color is still on category so let’s drag measure measure values and put it on color
if I click on the drop down I’ll measure values and select use separate Legend I can change the scale so I can set the East values
the orange and the West values to be blue
and now we have two separate diverging colors in a bubble chart you can also add something like segment to expand this out hope this helps