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.
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 - [email protected]
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.
Can you provide a screenshot of the data you are referencing?
These are manually inputted
Are you just referencing that single cell?
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
That did it, thanks @Paul Newcome
Happy to help. 👍️
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%.
©2022. All Rights Reserved Smartsheet Inc.