Portfolio Report Pie Chart
I'm trying to develop a pie graph based on a sheet of projects with R/Y/G reporting. Basic pie graph with % of total by status indicator.
The issue I'm getting is that SmartSheet requires integers for graphs, I think. If anyone has a workaround please let me know. I could assign an integer based on R/Y/G status, but then how do I represent R/Y/G instead of the integer value?
Comments
-
YOu could build a chart as below...
.
Color Count Helper
R formula Red
Y formula Yellow
G formula Green
.
The formula would be:
.
(on a separate sheet)
=COUNTIFS({Main Sheet Range 1}, Helper@row)
.
(on the same sheet)
=COUNTIFS([RYG Column]:[RYG Column], Helper@row)
.
This will pull your counts. When building the pie chart you would select the first two columns. Your labels would then be "R", "Y", "G", or you could do away with the legend entirely and just change the colors of the chart to reflect the corresponding color counts.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 202 Industry Talk
- 430 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives