Legends show as separate lines

[ashrafkotb]

Hello,

I'm trying to plot a simple line chart with legends, pretty much like the below example:

https://www.youtube.com/watch?v=aOWyeIvpM2s

However, when I plot mine, the legends show as three separate lines, rather than colouring the same line with the different legend colours. Any clue what I might be doing wrong? 

[amitchandak]

@ashrafkotb , legend means three different lines.  It will look like one line only when it does have overlapping data

[DanielPozo · Accepted solution]

What happens is that in the example video, the categories occupy different years. Therefore, in the same year the Historical or Forecast category does not occur.

In your example the categories are present at the same time in some X-axis data, so when you place the legend you will see 3 different lines.

If you want to get the same video view, you must ensure that your data does not repeat the same categories for an X-axis data.