Names and lease expirations

[max3732]

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

[Steve=True]

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

[max3732]

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