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

QueenD
edited 12/09/19 in Smartsheet Basics

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

Comments

  • 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
    Gwyneth C Employee Admin

    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

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

  • Thank you Anthony and Gwyneth!

  • 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.
    Genevieve P. Employee Admin

    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