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
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives