Chart Colors
Am I doing something wrong in my setup of Pie Charts?
Pie chart colors should stick to their originally set up value even if there is no data to show. For example, my dataset has 5 columns selected. Let's presume for a moment that each column initially has the following values: 5, 8, 3, 9, 2. When creating the initial pie chart, I am able to select a color for each value set... let's say Red, Blue, Green, Yellow, Grey (in that order). Now, let's say a few days later column 3 has a value of 0... so the dataset now looks like 5, 8, 0, 9, 2. I would expect the pie chart to show the following colors: Red, Blue, Yellow, Grey. Instead, it shows up as Red, Blue, Green, Yellow. This is not an appropriate way for charts to work.