Smartsheet Basics

Smartsheet Basics

Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.

How can I get the legend for a pie chart to display ALL series even when their current value is 0?

✭✭✭✭✭✭

I've been having this issue while building dashboards for a while. I want to use a pie chart, the data contains 4 series. The values will update via their formulas over time, but right now the value for 3 of the 4 series is 0. For all of the other types of graphs, all series are displayed in the legend regardless of their values (for example, in a bar graph all of the series show up on the axis & in the legend even if their current value is 0). However, when I choose pie chart (or donut), the series don't show up if the value is 0, meaning the only thing that shows up in the legend is the series with a value above 0. Furthermore, when the values for the other series update, they get added into the pie chart & legend, but then my series colors get all messed up & I have to go back & fix them. How do I fix this so all of the series show up in the legend even if their current value is 0?

Tags:

Best Answer

  • ✭✭✭✭✭
    Answer ✓

    @ro.fei I ran into this before... @Debbie Sawyer had a great solutions for that here

    Chart Colors

    Basically you add a column where you take your value and add .0000001 so that none of the values are truly zero.

Answers

  • ✭✭✭✭✭
    Answer ✓

    @ro.fei I ran into this before... @Debbie Sawyer had a great solutions for that here

    Chart Colors

    Basically you add a column where you take your value and add .0000001 so that none of the values are truly zero.

  • ✭✭✭✭✭✭

    @sharkasits It worked!!! Thank you so much!

Trending in Smartsheet Basics