Compare records in chart

[appleskrott]

I have a newbie question. Hoping someone can help me out, or point me in the right direction.

I have a file with two main databases:

1. employees

2. how each employee does in sales per day.

So I have nice lists with a day-to-day sale overview for each employee.

Easy to make a chart for each employee - but I would like to do a graphical comparison as well.

Now I would like to make a layout where I can compare "Employee #1" and "Employee #2" in a "line chart". The chart would have one lines for each employe showing sales over time. The horizontal x-axis would show dates, and the vertical y-axis would show amounts.

The best solution would be a simple finished solution with two drop down menus for choosing two employees - and that this generates a chart. The chart should be look just simple like this:

Does anyone know how do I make this work?

Thanks,

Appleskrott

[comment]

The chart would have one lines for each employe showing sales over time. The horizontal x-axis would show dates, and the vertical y-axis would show amounts.

That sounds simple enough - provided both employees worked on the same days. Otherwise it gets much more complicated.

[appleskrott]

That sounds simple enough - provided both employees worked on the same days. Otherwise it gets much more complicated.

Yes, the days are the same. I have tried a couple of different approaches, and my problem is that I can only choose one employee at a time. When I try to choose two employees the graph disappears. How do I solve this?

[comment]

Yes, the days are the same.

If you are sure of that, try it this way:

CompareChart.zip

[appleskrott]

If you are sure of that, try it this way:

Thank you! That worked perfectly for me!

[appleskrott]

One problem though. I seem to get the dates of some records in the wrong order. Starting with the newest date instead of the oldest. How do I fix this? And why does it only happen with a few employees?

[comment]

Try sorting the two relationships by Date.

And why does it only happen with a few employees?

Could it be because they backdated their data?