+ Reply to Thread
Results 1 to 3 of 3

Names and lease expirations

  1. #1
    Forum Contributor
    Join Date
    04-01-2010
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    173

    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

  2. #2
    Forum Contributor
    Join Date
    09-13-2011
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    216

    Re: Names and lease expirations

    Hi Max 3732,

    I am not sure about doing it with a scatter plot.

    Here is one I did in Excel using a Stacked Bar Chart.
    Tenant Timeline.xlsx


    Check it out and let me know if it meets what you wanted to do.

    Steve=True

  3. #3
    Forum Contributor
    Join Date
    04-01-2010
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    173

    Re: Names and lease expirations

    Sorry for taking so long to respond, but I do appreciate your help. That was what I was looking to do.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Date expirations
    By Gracieline in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 11-07-2012, 10:32 AM
  2. email to notify or display a list of discrepancies / expirations
    By mrmarchuk in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 02-13-2012, 11:46 AM
  3. Lease with residual
    By BRISBANEBOB in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-04-2010, 12:16 AM
  4. Formula to check expirations
    By jjjtrio in forum Excel General
    Replies: 9
    Last Post: 08-22-2009, 11:34 AM
  5. insurance expirations
    By pattibw in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-29-2006, 10:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1