3 Replies Latest reply on Oct 16, 2018 1:11 PM by Ken Flerlage

# Can polygons on maps have conditionally formatted borders?

It's easy to add conditionally formatted fill colors to polygons on maps by just dragging a variable to the color icon. Can the same be done with polygon borders? For example, if I wanted to fill each Metropolitan Statistical Area with a gradient from highest to lowest cost of living, can I then also color the borders with a gradient from highest to lowest population?

These fill colors are nice, but can I color the borders based on a variable too?

• ###### 1. Re: Can polygons on maps have conditionally formatted borders?

You can't change the color of the borders of a polygon based on data--it's a static color only, but you could create a dual axis chart. On one axis, you could have your polygons (I'd turn off the borders). On the other axis, you'd use a a line instead of a polygon, which would essentially create your borders. You might run into some issues here though because closing the polygon with a line requires that your first point be duplicated (it needs to be both the first and the last point).

Here's a simple sample workbook.

• ###### 2. Re: Can polygons on maps have conditionally formatted borders?

The dual-axis idea is interesting. Unfortunately in my specific situation, I need the other part of the dual axis to be circles on cities. Until they allow more than 2 dual axes, it looks like I'm probably a bit stuck.

• ###### 3. Re: Can polygons on maps have conditionally formatted borders?

Yep, I think you are probably stuck. In all honesty, I think trying to extract meaningful information from the color of the borders might be very difficult anyway, so perhaps there is a better way to show that information. One technique I've used is bi-variate mapping. The use case might not fit exactly what you're doing, but might be worth checking out. Here's a good blog by Sarah Battersby which shows how to do it in Tableau: How to make effective bivariate choropleth maps with Tableau | Tableau Software