Pie Charts - Can I force categories to display when the value is 0?
Hi all. I am having an issue with a pie chart. When I am looking at company wide data, I can assign a color to each series in a way that makes sense. However, when I filter into a specific area or sales rep, The colors do not make sense anymore. Is there a way to force a pie chart to display a series even when there is no data for it? This way series 1 is always series 1 even if there is no data for series 1 in your filtered data set.