I am trying to make a stacked bar graph. I have done this before when the group variables (i.e. the stacked bars) are known (e.g. Open, In Progress, Closed).
In some situations, the groups are unknown, highly variable (between refreshes), or numerous.
It is very easy to display this type of data proportionately in a pie chart. But it is not workable to do this in a stacked bar graph.
Here is my example: we conduct QC testing of various products. We have dozens of different tests. I want to show on a stacked bar chart how many of a particular test was performed in a certain period (let's say each week). I would normally create a series for each test (e.g. a series for test A01, A02, B11, etc.), but this is impractical when new tests are added or retired frequently.
It would be great to group values based on a variable set of groups without having to write dozens of series or update dozens of series each day/week.