Smart Category Grouping
Smart Category Grouping
Smart Category Grouping
Consider excel type data table with missing data points.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| Series 1 | 1 | 1 | 1 | 1 | ||||
| Series 2 | 1 | 1 | 1 | 1 | ||||
| Series 3 | 1 | 1 | 1 | 1 |
Each series will only contain the points with data. In this example, the names of data points for each series are as follows:
| Series 1 | C | D | E | F |
| Series 2 | E | F | G | H |
| Series 3 | A | B | C | D |
When all series do not contain points with same names, the chart will try to figure out the intended order automatically. Given the info above, it is enough to determine the correct order. Some overlaps in point names between series is required to logically conclude the correct result.