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

ro.fei

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?

sharkasits

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

https://community.smartsheet.com/discussion/67057/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

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

https://community.smartsheet.com/discussion/67057/chart-colors

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

ro.fei

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