Data relationship

[Bott74405]

Hello,

I try to show three values over time in a Line Chart. I have the data for each stream in seperate excel sheets.

When I create the chart, just two values seem to adapt to the month (y-axis) and the other one doesn't.

How can I make that all three values connect to the same month? I tried already to manage the relationship but it didn't help... Thank you

[Anonymous]

Hi  @Bott74405 ,

Can you check if another month column that does not match the value does not match the month column placed on the Y axis

Or another value that doesn't match this table that only has the month of January.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.