Sign in to join the conversation:
Hello,
I'm trying to select the pie chart, and it tells me that this chart type is not available. Any ideas?
Can you share a screenshot of your data? It looks like your missing data.
Check your columns. Pie Charts can only use 2 columns (Label and Number), and must have at least one label that has a number already above zero. If all amounts are zero, there is nothing to show on a Pie Chart, therefore it will not be an available option.
Did that work for you?
Not sure about the original requester, but it helped me.
Thanks!
What if I want to show a pie chart of projects by US region? i.e. we have a list of projects (column), the projects have a region (location) assigned to them (column), I want to calculate the percentage of projects for each region (total 100%). How do I do that? There is not a number value to calculate the percentage, but I should be able to take the number of projects for each region and calculate a percentage of the total number of projects.
Hi @TristanS
What I would do in this instance is create a Row Report from this sheet.
Then you can GROUP by the Region, and use the SUMMARIZE function to Count how many rows are in each Region. Once you have a Grouping and Summary row in your Report, you can use this Report as the source for your Chart. A Pie Chart will automatically create percentages out of those numbers.
Here's a webinar that goes through these features: Redesigned Reports with Grouping and Summary Functions
Cheers!
Genevieve
Hi everyone, I'm the owner of worksheet/workspace and am currently unable to reliably remove user access through the "Manage Access" panel. This issue just started occurring recently. The Problem: When I click the "X" next to a user's name to remove them, it works for the first user. For any subsequent user, the "X"…
I'm trying to move data from two grids (Grid #1 and Grid #2) using workflows (When rows are changed) to archive grids when a cell is ONLY updated on Grid #1. Here is my setup and what the issue I'm having… Grid #1 has the column that is being updated. Workflow setup on Grid #1 to move the row when the cell is changed to a…
Helloe Everyone! I’m trying to reference another sheet in Smartsheet, but I’ve noticed that sometimes it loads quickly, while other times it takes a very long time to display the list. Does anyone know why this happens? Is there a way to reduce how often this issue occurs? Today, I can’t get anything to load at all. 😑
