Formulas and Functions
Formulas and Functions
Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
Piechart does not reflect the correct percentage-Showing 100%
My pie chart is linked to a cell that says 25% complete. The pie chart says 25% but has (100%) next to it and shows a whole pie chart. I was hoping it would show only 25% of the pie not the whole pie.
Best Answer
-
Ok. You are going to want to insert a "helper column". You can hide this column after setting everything up to keep your sheet looking clean. In this column you are going to enter
=1 - Progress@row
This should give you the remaining percentage.
Next you will reference both of these cells for you chart, and you can finagle the various settings/colors/labels on the chart to effectively "hide" the remaining percentage by not showing the label and by setting it to white so that it blends in with your background.
Answers
-
Can you provide a screenshot of the data you are referencing?
-
These are manually inputted
-
-
Yes each pie chart is going to reference each individual cell. As you can see how I am hoping to have it work. This is for a high level view of where we are for each part of the project.
The 100% is true data and makes sense for the pie charts to show complete, but the issue is the 25% and any others showing the chart full and thats my dilemma
-
Ok. You are going to want to insert a "helper column". You can hide this column after setting everything up to keep your sheet looking clean. In this column you are going to enter
=1 - Progress@row
This should give you the remaining percentage.
Next you will reference both of these cells for you chart, and you can finagle the various settings/colors/labels on the chart to effectively "hide" the remaining percentage by not showing the label and by setting it to white so that it blends in with your background.
-
That did it, thanks @Paul Newcome
-
Could someone tell what does this number in parenthesis is showing, when you are just moving and pointing your mouse to specific pie(%)? how does the Smartsheet calculating those percentage (%)?
Appreciate your response.
-
That would be the percentage (out of 100) that each "slice" represents. So if half of the shown data is represented in the red slice, when you hover over the red slice it will show 50%.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 208 Use Cases
- 517 Announcements
- 5.6K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 84 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!