I am trying to put a pie chart in a "team report." The chart shows open issues for each team.
I would like to have the chart colored as follows: critical (red), high (orange), medium (green), low (blue).
I have no problem setting this up initially, however, as soon as I open the report for a team that doesn't have all four types of issues, the colors get thrown off (ie. high becomes green, medium becomes blue).
Is there anyway to create this chart or PivotChart so that the colors will be tied to the data series rather than the location on the pie chart?
I would like to have the chart colored as follows: critical (red), high (orange), medium (green), low (blue).
I have no problem setting this up initially, however, as soon as I open the report for a team that doesn't have all four types of issues, the colors get thrown off (ie. high becomes green, medium becomes blue).
Is there anyway to create this chart or PivotChart so that the colors will be tied to the data series rather than the location on the pie chart?
