The blue portion of the donut does not reflect 33% complete of the entire donut. How do I make the blue section represent the % more accurately?
For pie charts, you’ll need to include cells for each category that makes up 100%, but not include the total (i.e. summary of all categories). It will automatically sum the values from all categories to figure out what percentage of the whole that each category represents.
@Jason Duryea Thank you, but I am still not sure how to layout the data. If I want to show percent complete how would I lay out the below data points so that the donut chart is to scale? Total units 716. Total Units shipped 266. Percent complete 37%.
You would need another cell that identifies the number of remaining units.
716 - 266 = 450
Then the two data points you'll want in the chart are 266 for Shipped and 450 for remainder (which make a total of 716). Your Donut will show the percentage shipped versus remaining. Does that make sense?
The data source for your pie chart would reference cells with the grey selection box shown in the example below. I have numbers in my pie chart below, but if you switch it to percentage it will calculate correctly.
I'm sure this is super simple but myself and a colleague could not figure it out. I have some very simple data I need graphed for a project: Not Started, In Progress, Complete and then % Complete using the total. The pie chart for the Not Started etc. comes out correct: But when I ask it to graph just % complete, it does…
Hello, I am working on a training log for our company. I am trying to get the status color to turn green if training is completed, yellow if it is due in the future, and red if it is incomplete. I keep getting an incorrect argument. I had it working correctly when I was just doing red and green, but I really need that go…
Hi, I have a sheet that collects data from several forms. I have an automation that kicks off every Thursday at 5:00 AM to move all the data in the sheet to an archive sheet, I have another automation that is supposed to kick off at 8:00 on Thursday to check if the column is blank, then alert someone via an email to enter…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.