Dashboard - ability to color the series
Good Afternoon. I have a sheet tracking the article creation: Subject Matter Expert (SME), Article Status, Title of article, etc. I am creating a dashboard with several chart widgets based on the status within the sheet. There are 6 statuses. The MAIN widget is a grouped by status giving the total number of each status. The MAIN chart widget has color coded them based on the status (perfect). Now I am needing to create a chart widget for each staff member showing the status but want the color of each status to match that in the MAIN widget. Is this even possible?
Thank you in advance
Help Article Resources
Check out the Formula Handbook template!