How to Get Pie Chart to Show Total Complete VS. Incomplete


I feel like I am getting close to this one, but something is still not working out. I just want a simple Pie Chart to show total Complete Vs. Total Incomplete. I have tried using several different columns and strategies, and although this should be easy, it is not clicking…

Here is how I have it displayed now… and also a screenshot of the sheet I am using for data. I created a simple report with the data to chart that will update as they are completed.

Best Answer

  • KPH
    KPH ✭✭✭✭✭✭
    Answer ✓

    When adding your pie widget, you can select a data source and then highlight the cells with data in on your sheet with the totals:

    If you include all columns and use the Pie type:

    You should get a chart like this:

    Does that help?