How to Create Panel Chart Showing a Pie Chart

Published: 16 Jun 2023
Last Modified Date: 16 Jun 2023


How to create a panel style chart with pie charts all side by side for comparison.

The example below shows a pie chart of Sales by Subcategory, segmented by Region.

Current Behavior
User-added image

Article Solution
User-added image


  • Tableau Desktop


Please follow along with the attached sample workbook to the right of this text in the Attachments section.

Step 1

Connect to the sample data and create two calculated fields.

1. Connect to the Sample Superstore data from Tableau Desktop.
2. Create a new calculated field as follows:
     Name : Columns Size
     Calculation : int( (index()-1)/(round(sqrt(size()))))
3. Create a new calculated field as follows:
     Name : Rows Size
     Calculation : (index()-1)%(round(sqrt(size())))


Create a panel chart.

4. On the Marks card, change the mark type to Pie.
User-added image
5. Drag Sales to Angle on Marks.
User-added image
6. Drag Region to Color on Marks.
User-added image
7. Drag Sub-Category to Detail on Marks.
User-added image
8. Drag Columns Size to Columns and Rows Size to Rows.
User-added image
9. Right-click on Columns Size  placed on Columns then select Edit Table Calculation and set as follows:
User-added image
10. Right-click on Rows Size placed on Rows then select Edit Table Calculation and set as follows:
User-added image
11. Drag Sub-Category to Label on Marks.
User-added image
12. Drag Sub-Category to Filters and click OK.
User-added image
13. Right -click on Sub-Category placed on Filters and select Show Filter.
14. Right-click on Columns Size placed on Columns and select Show Header.
15. Right-click on Rows Size placed on Rows and select Show Header.
Did this article resolve the issue?