I am membership secretary for a society. I can create a scatter graph with x-axis = membership number (0-9999), y-axis = date of joining. I would like to create lines which go from date joining to date leaving (or present day if not left). I think I need to create a new chart type but maybe I don't need to? Can one of the existing chart types do it or perhaps someone has already created the chart type i need. Thoughts anyone?