How to make pie chart in tableau

In this blog post I am going to try and teach you how to make a pie chart.

A pie chart can be quite useful for grouped of data, that has varying quantities, and can readily be distinguished by the pie segments, usually about 3-4 segments is recommended. Pie charts are a good way to compare parts of data to a whole at a glance, especially when the segments are quite different, unlike in the data I've chosen here :(.

step 1: change automatic in the marks card to pie

How to make pie chart in tableau

step 2: drag the category field over the colour part on the marks card

How to make pie chart in tableau

step 3: drag the quantity field (value/measure) over the angle part on the marks card and change the view from standard to entire so the pie chart fits the whole workbook.

How to make pie chart in tableau

Hope this helps and works out for you too :)

Pie charts can be an effective visualization when showing part-to-whole relationships.  Often we see data as 100 percent and we want to know how a certain portion is relative to the total. Pie chart can be useful when we think of proportion in relative terms, however it is not the best visualization to represent an exact portion (e.g 19% vs 21%).  Further, it becomes more confusing when there are too many slices and too many things to compare to.  So be careful and be intentional when using this chart.

In Tableau, it is easy to create a Pie Chart.  Simply change the Marks card to "Pie" and the property "Angle" will appear, where a Measure is typically dragged to and will determine how big the slice is.    For example to get the Share of Regional Profit in the Superstore data set, we drag Profit to Angle.  

How to make pie chart in tableau

By default we see a big circle, the 100%.  And to determine what slices up the pie, it is typically a discrete Dimension that we drag onto color.  To identify what the slices are and how big they are, copy Profit and Region by pressing CTRL drag them to Label.   And to show the labels in percentage, click on Profit and add a Quick Table Calculation and select percent of total, which will give us the profit percentage.  And format the labels to give the pie more useful details.

How to make pie chart in tableau

To make a donut chart or a pie chart with a hole in the middle, a Dual-axis chart is needed.  Since there are no axis from our pie chart, create one by clicking an area in the columns and type in MIN(1), which may not really mean anything, but it is actually a continuous field that will give us an axis.  Create a second axis by duplicate the first one, by pressing CTRL and drag beside it then we have 2 pies.  

Resize the pie in the second axis and bring them together by clicking on dual axis. The middle circle or the second axis (right most) doesn't really have need to have any slices, so we just need to keep the sum of profit in the Marks card and adjust the size of the circle. Right click on the second axis, select dual axis to bring the 2 circles together and change the color to white.

How to make pie chart in tableau

Clean the charts up by hiding the headers and grid lines.

How to make pie chart in tableau

I personally think a donut chart may seem to look less cluttered than a traditional pie chart. And the white space in the middle is useful for an additional information and focus, like a total or a trend.     Nonetheless, visualization is an art.  Always remember consider style and purpose when creating charts.  

How to make pie chart in tableau

View Discussion

Improve Article

Save Article

  • Read
  • Discuss
  • View Discussion

    Improve Article

    Save Article

    In this article, we will learn how to draw a pie chart in tableau worksheet to do further operations.

    Tableau – a brief note

    Tableau may be a very powerful data visualization tool which will be employed by data analysts, scientists, statisticians, etc. to see the info and obtain a transparent opinion supported the info analysis. Tableau is extremely famous because it can absorb data and produce the specified data visualization output during a very short time.

    Pie chart in tableau

    A pie chart (or a circle chart) may be a circular statistical graphic, which is split into slices, for instance, numerical proportion. In a pie chart, the arc length of every slice (and consequently its central angle and area), is proportional to the number it represents.

    Dataset used in the given examples is Dataset.

    For this we have to import the data into tableau by following the steps below :

    1. Open Tableau tool and connect a dataset into it.
    2. Drag and drop the one sheet of the connected dataset.
    3. Click on sheet1 to open the tableau worksheet.
    4. On clicking Sheet1 you will get whole dataset attributes on the left side and a worksheet for work.

    To draw a pie chart you have to select minimum two attributes( one in row and one in column) by drag and drop then select the chart option as pie.

    Example 1:

    In this example we draw a pie chart by following simple steps :

    • Drag and drop two fields one for row and another for column.
    • Click on show me and select the pie chart
    • Increase the size of the pie chart by using size marks and select and drag.

    How to make pie chart in tableau

    Example 2:

    • Drag and drop the Profit field into the label marks to show the labels.
    • Click on Color
    • Change the color by choosing the new color palette.

    How to make pie chart in tableau

    Example 3:

    • Drag and drop the Sales field and then Region field into the label marks to show the labels.
    • Click on Color
    • Change the border color by choosing the other colors.

    How to make pie chart in tableau

    How do I create a pie chart for data in Tableau?

    Understanding the Steps Involved in Setting Up Tableau Pie Charts.
    Step 1: Load the Dataset. ... .
    Step 2: Construct a Bar Chart. ... .
    Step 3: Convert a Bar Chart into a Pie Chart. ... .
    Step 4: Increase the Size of the Pie Chart. ... .
    Step 5: Drag and Place Dimensions to Label Card. ... .
    Step 6: Apply Formatting to the Pie Chart..

    How do you create a pie chart with two measures in Tableau?

    Resolution.
    In the Marks card, select Pie from the drop down menu..
    Drag Measure Values to Size..
    Drag Measure Names to Color..
    Right click Measure Values or Measure Names on the Marks card and select Edit Filter….
    Select the measures you would like to include in your pie chart..

    Why can't I make a pie chart in Tableau?

    For pie charts you need both at least 1 dimension and at least 1 measure. Add a dimension to your viz and then try creating it again.

    How do I add a pie chart to a map in Tableau?

    Add the state to the chart by double clicking on state dimension or add the state dimension to details and move the longitude measure to columns and latitude measure to rows..
    Move the Number of store measure to the size mark. ... .
    Change the Mark type from automatic to Pie and use the size mark to resize the pie size..