Saving default colours for dashboard widget graphs

Harvey E

I have a dashboard widget that displays a pie chart.

The pie chart shows the number of high, medium and low priority "issues" recorded in a sheet.

I have built this into a workspace which I copy to use on various projects - sort of a template set equivalent.

Is it possible to "pre configure" the graph to use specific colours for each data type? ie, I would like it to show the number of "high" issues in red, "medium" in orange, and "low" in green.

What I find is that despite building the "template workspace" and setting up the pie chart with the right colours, as soon as I clear out the underlying sheet and save it, the dashboard no longer remembers the colour categories, so I have to reconfigure the dashboard.

Is there anything I can do to build my "workspace template" so I don't have to reconfigure the widgets each time? Or is this an enhancement request for the widgets to display data which doesn't yet exist with a particular style?

Thanks!

Paul Newcome

In the metrics sheet where you are gathering your counts, add 0.00001 then adjust the column's formatting to not show any decimals. It will display as zero, but since there is still technically data there it will act as a sort of placeholder and save your color options.

=COUNTIFS({Reference Sheet RYG Column}, @cell = "Green") + 0.00001

Paul Newcome

In the metrics sheet where you are gathering your counts, add 0.00001 then adjust the column's formatting to not show any decimals. It will display as zero, but since there is still technically data there it will act as a sort of placeholder and save your color options.

=COUNTIFS({Reference Sheet RYG Column}, @cell = "Green") + 0.00001

Harvey E

This is brilliant - thank you so much!

I've also now added a column called "None" so that when there are no issues in the log, it displays as 100% and "Grey", when there are issues in there, it sets to 0.00001 and doesn't display. Works perfectly!

Paul Newcome

Happy to help. 👍️

Christine Cao

I'm using reports to do the "count" instead of a Metrics chart that hard codes, because I thought that was a way to set the "colors". That was working okay until recently where I now have seen all my charts across 200 projects randomly changing across the entire workspace of projects. Unless I go back into EACH chart to change back but there's also no guarantee it will stay as it changes all the time.