What's with the "unnamed series" in the pie chart?

So I've created a pie chart in my Dashboard and let's say I have basic data such as:

Apples 5

Oranges 12

Bananas 8

Blueberries 20

Strawberries 3

Rasberries 19

With this data, when I tried to import it as shown above, it gave me an error. When I imported only the values/numbers, it worked. However, now I cannot show which one is which. Without the labels in the pie chart, how is the legend useful?? Not to mention that I have six (6) colors in my legend, but they're all called "unnamed series" and there's no way for me to edit them/specify(e.g. Apples, Oranges, etc.) It only lets me edit the color, but not the name. This is sooooooo frustrating!

Please tell me that I'm overlooking a step or doing something wrong, because if this is standard pie chart behavior, both the Development & QA teams @ Smartsheet need nothing but coal in their stockings for Christmas.

Please help!!

Smartsheet Pie Chart.PNG

Find more posts tagged with

Government

Reports

Support

Dashboards

Comments

Anthony Bryan

Hi QueenD,

I'm sorry you're having troubles. At this time, you can not edit key names from the chart - it must be done from within the source data sheet. In the example you provided, you'd need to have the pie labels in a column adjacent to your numerical values. Please see the attached screenshot for an example.

Screen Shot 2018-03-19 at 11.39.01 AM.png

Gwyneth C

Hi!

For Pie Charts, you may also need to use this tip...

TIP: If your data in the chart doesn’t look as you’d expect it to, try clicking Switch rows/columns.

For more information about how to set up chart data so that you get the results you want, take a look at this article in the Help Center:

https://help.smartsheet.com/articles/2476691-compare-live-data-with-a-chart

-Gwyneth

QueenD

Thanks Anthony, I figured that was the issue. I still wish these pie chart widgets were more intuitive, but this will do for now.

QueenD

Thank you Anthony and Gwyneth!

Amru

When will we be able to change the series label?

Has anyone been able to find a fix?

It is a very important feature and would be very helpful for us to be able to change series name withou having to alter the source.

Genevieve P.

https://community.smartsheet.com/discussion/comment/327191#Comment_327191

Hi @Amru

Chart Widgets display data based on how the source information is configured. If you would like to display different labels for the data points, I would suggest adding a helper column to the source sheet that you can use for the series labels and excluding the original column from the Chart.

Please also let the Product team know that this is something you would like to be able to configure right from the Chart widget by filling out this form, here.

Cheers,

Genevieve

Sign in to join the conversation!

Quick Links

Trending discussions

How to restrict Form responses to data existing in the related Sheet
I am trying to create a Form that requires the user to supply information related to any item existing in the Primary Column. If I pull that existing field into my form, the user entry is a free-form field and I can't figure out how to restrict it (other than validating by data types). If I add a new field with a dropdown…
Sheet -Ganhtt Chart
Is it possible to display both the planned and actual duration for a single task on a Smartsheet Gantt chart? I would like the Gantt bar to show the planned duration (e.g., in blue) based on a Planned End Date column, and then show the actual duration (e.g., in green) based on an Actual End Date column. Can the Gantt view…
Color-Coded Tags in Board View
I noticed in the Board View tags are grey by default but in the how to videos, in the Board View some of the tags are colorful. I'd like to leverage that same functionality as I'm building a research repository with many different types of research in it and a visual cue would be lovely. Can anyone assist? I attached a…