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

Answers

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

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

    thinkspi.com

  • These are manually inputted

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Are you just referencing that single cell?

    thinkspi.com

  • 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

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Happy to help. 👍️

    thinkspi.com

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

    thinkspi.com