Locking in Colors for Charts in Dashboards (Avoiding category colors changing with dynamic data)
I am having an issue with Pie charts changing colors when data in the underlying sheets is altered.
For example. If I have a pie chart with categories for task status: Not Started, In Progress, and Completed. Lets say I designate those colors Red, Yellow, and Green in the Pie Chart.
If the underlying data changes so that an individual currently has no "In Progress" tasks (for example). The loss of a category of data (or addition), seems to revert colors to defaults and throw off the color scheme of the dashboard. So for example all of a sudden the Not Started part of the pie turns to blue.
Is there some way around this, or something I am not doing correctly? Thanks,