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

0

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.

0

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?

0

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

0

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!

0

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?

0

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?

0

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