Create Filled Maps with Pie Charts in Tableau
The pie mark type can be useful to show simple proportions to a relative whole. For example, pie marks might be effective when you want to show the percentage of profit for a product by geographic location.
In this example, the pie mark type is used with the filled maps mark type to show the percentage of profit for office supplies, furniture, and technology, relative to the total profits by state. It uses the Sample-Superstore data source that comes with Tableau Desktop.
Build the map view
In Tableau, open a new workbook and connect to the Sample-Superstore data source.
- On the Data Source page, click Sheet 1 to go to a new worksheet.
In the Data pane, under Dimensions, double-click State.
Tableau creates a symbol map, with a data point for each state in the Sample-Superstore data source.
On the Marks card, click the Mark-type drop-down and select the Map mark type.
From Measures, drag Profit to Color on the Marks card.
From Measures, drag Latitude (generated) to the Rows shelf, and place it to the right of the other Latitude field.
You should now have two identical map views.
On the Rows shelf, right-click the second Latitude field and select Dual Axis.
The second map is now layered on top of the first map. There are now three drop-downs on the Marks card: one for each map view, and one for both views (all). These are three separate marks cards that you can use to control the visual detail for each of the map views.
On the Marks card, click one of the Latitude (generated) tabs, and then click the Mark type drop-down and select the Pie mark type.
From Measures, drag Sales to Size on the Latitude (generated) Marks card you selected.
The Sum of sales for each state is shown as text.
From Dimensions, drag Category to Color on the same Marks card.
If the size of the pie charts is too small, click Size on the Marks card to adjust the size.
The map view now shows the sum of profit, as well as the sum of sales for each category, for each state.