Pie Chart in Tableau

A pie chart represents data as slices of a circle with different sizes and colors. The slices are labeled and the numbers corresponding to each slice are also represented in the pie chart. You can select the pie chart option from the Marks card to create a pie chart.

Choose one dimension and one measure to create a simple pie chart. Here I am taking the dimension named Region with the measure named Profit.

Drop the Region dimension in the colors and label marks. Drop the Profit measure into the size mark. Choose the chart type as Pie. The following chart appears which shows the 4 regions in different colors.
pie-chart-with-colours-tableau

Tableau Workspace and Navigation

Crosstab Chart in Tableau

A crosstab chart in Tableau is also called a Text table, which shows the data in the textual format. The Crosstab chart is made up of one or more dimensions and one or more measures.

You can see various calculations on the values of the measured field such as running total, percentage total, etc.

Here, I am using the Sample-superstore to demonstrates this example. Let's plan to get the number of sales for each segment in each region. You need to display this data for each year using the order dates available.

Follow the below steps in the Tableau worksheet :

  • Open Tableau and click on Connect to Data.
    connect-to-data-tableau
  • Then the Connect page will open, click on Microsoft Excel.
    click-on-connect-to-data-excel-file-tableau
  • Navigate to the downloaded files, select Sample Superstore.xls excel file, which is a saved excel file, and click on Open.
    connect-sample-superstore-to-tableau
  • You can download a Sample Superstore.xls file from the link: https://chercher.tech/files/
  • Once the data source has been connected, open a new worksheet by clicking on sheet1.
    naviagte-to-sheet1-tableau
  • The Sample Superstore excel file contains the below details.
    sample-superstore-excel-file-tableau
  • Drag and drop the dimension order date to the column shelf.
  • Drag and drop the dimensions region and segment to the rows shelf.
  • Pull the measure Sales to the labels Shelf under Marks.
  • Then you see the following crosstab as below:

crosstab-chart-tableau

You can encode these crosstab values with colors by dropping the measure field into the color shelf as shown below.
coloured-cross-tab-tableau

In addition to the color encoding, you can also perform calculations applied to the values from the measure field.

In the following example, we apply the calculation for finding the percentage total of sales in each row instead of only the sales figures. For this,

  • Right-click on SUM (Sales) present in the marks card and choose the option Add Table Calculation.
  • Then, choose the percent of the total and summarize it as Table (Across). add-table-calculation-to-crosstab-tableau
  • Now, you can see that the crosstab chart created with percentage values as shoe below.
    crosstab-values-with-percentage-tableau
0 results
Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions