Newbies appleskrott Posted February 21, 2012 Newbies Share Posted February 21, 2012 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 Link to comment Share on other sites More sharing options...
comment Posted February 21, 2012 Share Posted February 21, 2012 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. Link to comment Share on other sites More sharing options...
Newbies appleskrott Posted February 21, 2012 Author Newbies Share Posted February 21, 2012 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? Link to comment Share on other sites More sharing options...
comment Posted February 21, 2012 Share Posted February 21, 2012 Yes, the days are the same. If you are sure of that, try it this way: CompareChart.zip Link to comment Share on other sites More sharing options...
Newbies appleskrott Posted February 21, 2012 Author Newbies Share Posted February 21, 2012 If you are sure of that, try it this way: Thank you! That worked perfectly for me! Link to comment Share on other sites More sharing options...
Newbies appleskrott Posted February 22, 2012 Author Newbies Share Posted February 22, 2012 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? Link to comment Share on other sites More sharing options...
comment Posted February 22, 2012 Share Posted February 22, 2012 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? Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4447 days old. Please don't post here. Open a new topic instead.
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 accountSign in
Already have an account? Sign in here.
Sign In Now