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.

Find more posts tagged with

color

Accepted answers

Kerry St. Thomas

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!

All comments

Kerry St. Thomas

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.

Good luck!

James Preston

Thanks Kerry, I thought as much but wondered if I was missing another trick.

Many thanks

Paul Newcome

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.

James Preston

This is interesting, I'll have a play around with this.

Thanks Paul.

Paul Newcome

Happy to help. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.