Image I've got the following data:
X Y
AAAAA 1
AAAAA 2
BBBBB 3
BBBBB 4
BBBBB 5
CCCCC 6
CCCCC 5
etc
Now I want to show them in Line Chart, so that X is X axis, and Y is Y. A set the XCategory to X and YValue to Y. However, I only see the distinct values of X, like
AAAAA 0
BBBBB 3
CCCCC 6
How do I "ungroup" them?