Pie chart

This chart shows a proportional relationship of different categories to a total using circle segments (sectors). The entire circle area is 100% and corresponds to the sum of all categories. The area of each segment corresponds to the percentage of a category in the total amount. Pie charts are a good choice for demonstrating proportions of a small number of segments.

pie-chart

Source table
Product categoriesSales
Home appliances69M
Household goods57M
Household cleaners44M

Sections in the wizard

Section
in the wizard
Description
ColorDimension. You can only specify one field here.
MeasuresMeasure. You can only specify one field here.
SortingA measure or dimension from the Color section. Affects area sorting. The sorting direction is marked with an icon next to the field: ascending or descending. To change the sorting direction, click the icon.
SignaturesMeasure. Displays measure values on the chart. To add callouts with category names to the chart, drag the Measure Names dimension to this section.
FiltersDimension or measure. Used as a filter.

Creating a pie chart

To create a pie chart:

  1. On the DataLens home page, click Create chart.
  2. Under Dataset, select a dataset for visualization.
  3. Select Pie chart as the chart type.
  4. Drag a dimension from the dataset to the Color section.
  5. Drag a measure from the dataset to the Measures section. The values are displayed as pie chart areas.

Recommendations

  • If there are more than 4-6 segments per chart, group the smallest of them as Other. A larger number of segments overloads a chart and makes it difficult to understand the data.
  • You cannot display negative and null values on this type of chart.
  • Do not use pie charts to show changes to proportions over time or for precisely comparing data by category.