I have two data fields Name and Year. The year data is a point in time. IE Name = Smith; Year = 2000, 2001, 2005. I need to create a graph plotting the # of years a person served on our board of directors. Not the count of years but the actual year he/she served, hence it should look like a milestone graph. I can’t seem to make it happen with the Excel 2007 chart types.
