Hey all,
I really do not know how to do charts either a query or VBA, not my cup of tea but it needs to be done. As you can see in my diagram, on top I have 1 textbox for a date with date picker, on the right of that I have a combo box that loads user names from a database. I also have a chart where on the X axis I need the user name to appear by selection. On the Y axis I need an 8 hour time window from 6am to 230pm. As for the data I need to query the main table and find the keyword "INDIRECT" and put that in as the data on half of the stacked column, on the other half whatever is not "INDIRECT" probably just a wildcard * I need that to display as well. Any thoughts?
Attachment 47457