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.

Find more posts tagged with

Sheets

Reports

Dashboards

Accepted answers

KPH

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?

All comments

KPH

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?

Curculese

So simple…. I've been trying this in so many ways lol… That works. Thank you so much.

KPH

Glad we got you moving. Sometimes when you try too many things the simple solutions are the hardest to find.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.