Sign in to follow this  
Followers 0

Compare records in chart

7 posts in this topic

Posted

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:

post-106154-0-76233600-1329833999_thumb.

Does anyone know how do I make this work?

Thanks,

Appleskrott

Share this post


Link to post
Share on other sites

Posted

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.

Share this post


Link to post
Share on other sites

Posted

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?

Share this post


Link to post
Share on other sites

Posted

Yes, the days are the same.

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

CompareChart.zip

Share this post


Link to post
Share on other sites

Posted

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

Thank you! That worked perfectly for me!

Share this post


Link to post
Share on other sites

Posted

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?

Share this post


Link to post
Share on other sites

Posted

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?

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0