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
-
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?
Answers
-
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?
-
So simple…. I've been trying this in so many ways lol… That works. Thank you so much.
-
Glad we got you moving. Sometimes when you try too many things the simple solutions are the hardest to find.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 458 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives