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

QueenD · 03/19/18

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

Anthony Bryan · 03/19/18

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 · 03/19/18

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 · 03/22/18

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 · 08/15/18

Thank you Anthony and Gwyneth!

Amru · 04/24/22

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. · 04/25/22

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

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

Comments

Categories