Help Creating a Column Graph that Denotes Time

[arsenalsweep]

Hi All,

I am trying to create a column graph that shows how time is spent thoughout the day. For example, I want to show the hours 9 am - 5 pm, with the top of the column representing 9 am and the bottom of the column representing 5 pm. Within the 9 am - 5 pm range I want to split the time up to show different acticivites:

9 am- 10 am: Workday prep
10 am - 1 pm: Meetings
1 pm - 1:30 pm: Lunch
1:30 pm - 5 pm: Work at desk

I want to denote each of these sections as a different color within the 9 am - 5 pm colulm so it basically looks like an agenda, but can be used to input different times so we can visually see how workdays have been spent based on data.

If I can manage to complete the first step,I would additionally like to be able to insert several horitontal lines denoting specific times throughout the day where certain activites happen (e.g. meeting starts - a specific time, not a period of time).

Thanks in advance for any help and if anything is unclear I will attempt to clarify.

 

[DonkeyOte]

Which version of Excel are you running ?

With a setup along the lines of:

Excel Workbook
	A	B	C	D
1	Start	End	Duration	Activity
2	09:00	10:00	01:00	Workday Prep
3	10:00	13:00	03:00	Meetings
4	13:00	13:30	00:30	Lunch
5	13:30	17:00	03:30	Desk
Sheet8

You could create a Pivot Chart with Start as Column Label/Field and Duration as Data Field set to calculated as % of Row
(order start from newest to oldest to have 09:00 at head of column)

 

[arsenalsweep]

Thanks for the advice! I decided to go with a different tactic to display the info, but this was still helpful!