Displaying poll results using the pie chart component

Pie charts are a useful way of displaying poll results.

In our example, the pie chart component is used to display three categories of responses: Yes, No, or Not Sure.


Goal: Use COUNTDISTINCT and GROUP functions to visualise poll results.

  • Values: COUNTDISTINCT( B:B )
  • Labels: GROUP( B:B)

Where B:B is the column that contains the poll results.



Date Poll Result
3/18/2013 Yes
4/18/2013 Yes
4/18/2013 Yes
5/18/2013 No
6/18/2013 Not Sure
7/18/2013 Not Sure
8/18/2013 Not Sure