Forum Discussion
Line Chart - Multiple values with legend
Good Morning,
i need a line chart that shows 3 different fields (as values) and include a legend.
Imagine this example:
| ITEM | VALUE 1 | VALUE 2 | VALUE 3 |
| A | 3 | 6 | 8 |
| A | 5 | 5 | 4 |
| A | 6 | 8 | 4 |
| B | 5 | 3 | 3 |
| B | 3 | 6 | 2 |
| B | 2 | 7 | 2 |
| C | 4 | 8 | 5 |
| C | 6 | 3 | 6 |
| C | 7 | 2 | 8 |
| D | 8 | 5 | 8 |
| D | 8 | 2 | 7 |
| D | 3 | 4 | 6 |
If I add more than one of the values, I can not include item as a legend. Is there any way to do it?
Thank you,
Jaime
Hi Anonymous ,
this is actual not possible.
This is still an idea to add two or more values and a legend in a line chart.
Best regards
5 Replies
Hi Anonymous , thanks for answering.
I've done a much better example where you see what the problem is:
Forecaster Forecaster production Real production Production offered DATE A 3 6 6 20/01/2018 A 5 5 6 21/01/2018 A 6 8 7 22/01/2018 B 5 6 6 20/01/2018 B 3 5 6 21/01/2018 B 2 8 7 22/01/2018 C 4 6 6 20/01/2018 C 6 5 6 21/01/2018 C 7 8 7 22/01/2018 D 8 6 6 20/01/2018 D 8 5 6 21/01/2018 D 3 8 7 22/01/2018 This is my table and i want to see in a line chart 6 lines (one for each forecaster, other of "Real production" and the last one of "Production offered.
Now, i only see 2 ways to do this line chart:
1- Value: forecaster production and legend: forecaster (4 lines)
2- Values: forecaster production, real production and production offered (3 lines)
I need to show all, but i dont know how i can do it....
Any help?
Hi Anonymous ,
this is actual not possible.
This is still an idea to add two or more values and a legend in a line chart.
Best regards