Chart Showing Users start and finish times

pollardd

New Member
Joined
May 24, 2018
Messages
1
Hi Guys,
I'm having a bit of a brain strain with this one so I thought I would try and get some help to point me in the right direction.
I have a SQL Database with a table containing a data with user IN and OUT times
My data looks like this in an SQL Query

UsernameChange TimeStatus
bob2018-05-01 09:00:01.000IN
bob2018-05-01 10:00:03.000OUT
bob2018-05-01 11:05:04.123IN
bob2018-05-01 17:05:05.111OUT
sue2018-05-01 08:59:00.001IN
sue2018-05-01 17:00:00.000OUT
sue2018-05-02 09:00:01.000IN
sue2018-05-02 17:05:00.000OUT

<tbody>
</tbody>

















I'm trying to create a Graph or Chart in Excel (2010) that will display users down the left side and dates / times across the bottom.
A bar for each user running left to right will start at the time when the user is set to IN and finish when the user is set to OUT a bit like a Gantt chart.

I created an SQL view that selects the data I want in SQL Server.
I have created a Data Source in Excel that connects to that view.

Here is where I'm not sure of the best approach.
I have been mucking around with Pivot tables and charts but it keeps trying to summarize my data which I don't want.

I have simply imported the Data as a Table and this worked and when I click Refresh all I see the updates so that's working.

The data is no longer sorted in the order of my SQL Query. Looks to me like it is purely sorted by Date/Time.

Once I have the chart working I'd like to be able to vary the start and finish date and turn users on or off.
This way a manager can zoom in on just the data they want to see.

How can I achieve this in Excel.

Thanks in advance
David
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Watch MrExcel Video

Forum statistics

Threads
1,122,625
Messages
5,597,230
Members
414,133
Latest member
lucid33

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top