Donut Chart color change

Options

Hi, is it possible to fix colors for a donut chart? For my dashboard I have several reports from where I get data. I have the same structure, but if one value is empty the colors change. So e.g. normally I have 5 rows. and therefor in my dashboard 5 colors. But if one row in my report is 0 than I only have 4 colors/values in my donut chart and colors changes. It would be great if the color for each row would be the same. Is there a solution for that?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!