Excel 2007 Horizontal Bar Chart with fixed time frame
I am trying to develop a horizontal bar chart to show some real estate holdings. The chart will show when my lease expires and how long it will be occupied. Not every property will be occupied until the conclusion of the lease. I have numberous properties I need to show so I would like to show a fixed time frame as I move from left to right across the chart. I would like to start with 3/31/13 and fixed quarterly time periods (6/30, 9/30, 12/31) through 12/31/2018.
I picture it showing the properties down the left, each property would have a horizontal bar showing the length of the lease and then a bar directly below it showing how long the property will be occupied. I don't know how to make my time frame the fixed quarterly time periods as I describe above....any thoughts? Below is a sampling of my data. Thanks!
Lease Expries Occupied Until
NYC 8/31/2014 12/31/2014
Tokyo 3/31/2013 3/31/2013
London 12/31/2015 8/31/2013
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1