trevorsteer
New Member
- Joined
- Mar 19, 2012
- Messages
- 1
Hi there,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o></o>
<o></o>
I'm attempting to chart data obtained from our phone system to see when users are logged in/on rest. <o></o>
<o></o>
I’m using Excel 2007.<o></o>
<o></o>
The data we extract has:<o></o>
person | status | start | finish | duration<o></o>
<o></o>
Status is either “login” or “rest”<o></o>
Start/finish is time (h:mm)<o></o>
Duration is a formula (h:mm, finish - start)<o></o>
<o></o>
I want to have a stacked bar chart that shows when a person was logged in/on rest; one bar for each person.<o></o>
<o></o>
x-axis: person<o></o>
y-axis: time (8am – 6pm)<o></o>
legend: status<o></o>
<o></o>
The problem I’m encountering is that each person logs in and out multiple times throughout the day (therefore, has multiple lines to their name in the data), and I can’t get this information to appear on a single bar for each person.<o></o>
<o></o>
I've sorted the data into a pivot table which gives me the information I want, but I can’t figure out how to get the chart.<o></o>
<o></o>
Row labels<o></o>
a. Person<o></o>
b. status<o></o>
c. start<o></o>
<o></o>
Values<o></o>
Min of duration<o></o>
<o></o>
I’ll be very appreciative of any help. I’m happy to email the spreadsheet I’ve worked on thus far.
<o></o>
Ideally, I would like to avoid using a Gantt chart within cells (as it would involve vlookup/if statements), but am beginning to think that’s my only option...
fficeffice" /><o></o><o
></o>I'm attempting to chart data obtained from our phone system to see when users are logged in/on rest. <o
></o><o
></o>I’m using Excel 2007.<o
></o><o
></o>The data we extract has:<o
></o>person | status | start | finish | duration<o
></o><o
></o>Status is either “login” or “rest”<o
></o>Start/finish is time (h:mm)<o
></o>Duration is a formula (h:mm, finish - start)<o
></o><o
></o>I want to have a stacked bar chart that shows when a person was logged in/on rest; one bar for each person.<o
></o><o
></o>x-axis: person<o
></o>y-axis: time (8am – 6pm)<o
></o>legend: status<o
></o><o
></o>The problem I’m encountering is that each person logs in and out multiple times throughout the day (therefore, has multiple lines to their name in the data), and I can’t get this information to appear on a single bar for each person.<o
></o><o
></o>I've sorted the data into a pivot table which gives me the information I want, but I can’t figure out how to get the chart.<o
></o><o
></o>Row labels<o
></o>a. Person<o
></o>b. status<o
></o>c. start<o
></o><o
></o>Values<o
></o>Min of duration<o
></o><o
></o>I’ll be very appreciative of any help. I’m happy to email the spreadsheet I’ve worked on thus far.
<o
></o> Ideally, I would like to avoid using a Gantt chart within cells (as it would involve vlookup/if statements), but am beginning to think that’s my only option...
