Rename labels when using custom colours
I am using Symbols in my sheet for 'risk level' using the standard Red, Yellow & Green.
I then have a report showing how many/what percentage of risk we have per risk status above.
I have added the report as a widget into a dashboard and am using my companies branded colours in a donut chart, however the label of each colour still displays per the symbol on in the sheet per below screenshot, which looks rather confusing as you see 'Red' but its actually Blue.
Q: How can I update the labels to show as Blue & Grey rather then Red & Yellow.
I'd still like the sheet to display Red, Yellow & Green as these are the standard traffic light colours.
Best Answer
-
Since "Red" "Yellow" and "Green" are actual data points on your sheet, you can't just rename the legend without renaming the underlying data. So as I see it, you have two options:
—change the Dashboard widget so the colors match the "Red/Yellow/Green" convention on the sheet
—change the sheet data to the blue/green/grey convention on the dashboard.My suggestion would be to go with the first option. You can modify the colors on your chart by choosing "Edit" for the Chart widget, scroll to "Series", change the dropdown to each individual series in turn and then input each color.
Good luck!
If this answer resolves your question, please help the Community by marking it as an accepted answer. I'd also be grateful for your response - "Insightful"or "Awesome" reactions are much appreciated. Thanks!
Answers
-
Since "Red" "Yellow" and "Green" are actual data points on your sheet, you can't just rename the legend without renaming the underlying data. So as I see it, you have two options:
—change the Dashboard widget so the colors match the "Red/Yellow/Green" convention on the sheet
—change the sheet data to the blue/green/grey convention on the dashboard.My suggestion would be to go with the first option. You can modify the colors on your chart by choosing "Edit" for the Chart widget, scroll to "Series", change the dropdown to each individual series in turn and then input each color.
Good luck!
If this answer resolves your question, please help the Community by marking it as an accepted answer. I'd also be grateful for your response - "Insightful"or "Awesome" reactions are much appreciated. Thanks!
-
Thanks Kerry, I thought as much but wondered if I was missing another trick.
Many thanks
-
You can use a separate sheet with formulas containing cross sheet references.
Put the desired labels in one column and in the next column a COUNTIFS to count how many are for that color.
-
This is interesting, I'll have a play around with this.
Thanks Paul.
