Piechart does not reflect the correct percentage-Showing 100%

Brendan West

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.

Paul Newcome

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.

Paul Newcome

Can you provide a screenshot of the data you are referencing?

Brendan West

These are manually inputted

Paul Newcome

Are you just referencing that single cell?

Brendan West

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

Paul Newcome

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.

Brendan West

That did it, thanks @Paul Newcome

Paul Newcome

Happy to help. 👍️

Des_Con

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.

Paul Newcome

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%.