A user wanted to know how to create an Excel chart that shows when his tenant’s leases are expiring. He wanted to put this into a chart. How would you create this chart in Excel? Read the post below. There are probably many ways to solve this question. Please let me know in the comments below how you would create this Excel graphical representation of a tenant’s timeline. Read on and let me know. On Monday, I will post a step-by-step tutorial and video demonstration of my solution. See you soon!
Names and lease expirations
I’m trying to figure out how to create a chart showing names and the corresponding lease expiration in Excel 2007.
There is 1 column with the name of tenants and the next column has the date the lease expires. They are labeled “tenant” and “lease expiration”, respectively. Out of the 15 tenants a couple have text instead of dates.
I was thinking of a scatter plot, with the names of the vertical access and dates on the horizonal, but can’t figure out how to do this. Any help would be greatly appreciated
Here is how I set up my data so that you can create your own chart:
| A | B | |
|---|---|---|
| 1 | ||
| 2 | Tenant | Lease Expiration Date |
| 3 | Mike | 11/16/2013 |
| 4 | Mary | 8/5/2013 |
| 5 | John | 10/17/2013 |
| 6 | Jack | 12/18/2013 |
| 7 | Justin | 8/26/2013 |
| 8 | Steve | 8/14/2013 |
| 9 | Mark | 7/28/2013 |
| 10 | Tony | 9/24/2013 |
| 11 | Sam | 11/8/2013 |
| 12 | Steph | 10/30/2013 |
| 13 | Joe | 9/13/2013 |
| 14 | Frank | 8/6/2013 |
| 15 | Monty | 9/9/2013 |
| 16 | Macy | 12/15/2013 |
| 17 | Yani | 11/14/2013 |
Sheet1
Also, don’t forget to subscribe to my blog so that you can get the next post and specials delivered directly to your inbox.
Steve=True
I made an effective chart out of the data by using a stacked bar chart. I added 2 columns to the data. First: todays date =Today(), and second, the time until the lease expires (the date lease expires-today’s date).
I adjusted the horizontal axis to start on today. The resulting chart is a bar chart showing the duration until the lease expires.
Great one Pete!