Chart from table lagging when one argument has multiple values
Hello allmighty Experts,
I have a problem!
I need to a plot showing that Value is in Spec for each Set.
| Character | Set | Value | Spec Max | Spec Min |
|---|---|---|---|---|
| A | 1 | 0.6 | 1 | -1 |
| B | 2 | -0.2 | 1 | -1 |
| C | 3 | 1.5 | 1 | -1 |
| D | 4 | -0.3 | 1 | -1 |
Spec is always the same, so should show up as a horizontal line.
However, when I have two rows corresponding to the same Set my Spec line is broken.
| Character | Set | Value | Spec Max | Spec Min |
|---|---|---|---|---|
| A | 1 | 0.6 | 1 | -1 |
| B | 2 | -0.2 | 1 | -1 |
| C | 2 | 1.5 | 1 | -1 |
| D | 3 | -0.3 | 1 | -1 |
Anyone has an idea how I could solve this? I often have multiple values corresponding to the same set.
Cheers
Kai
1 answer
Hi @Kai Winter ,
Seems that the behavior is correct: you can't have two identical numbers (values) on the axis. The graph is confused which "two" from which row we need to take.
In your Character column all your values are unique, maybe you can take them for X-axis instead of the Set column?
The same happens if I call my Set a different way
Also Spec Min takes the value -2, which doesn't exist in the table.
Is there a way to plot horizontal lines in a line plot additonaly to the main data?
In Gantt chart there is an option of using 2 tables under one Chart from table macro:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.