MrExcel Publishing
Your One Stop for Excel Tips & Solutions

date ranges in charts

Posted by Heather on February 04, 2002 10:14 AM

Hi. I have a list of names of board members that have served through various years (ex.: John Smith 1996-2000). I'd like a bar chart with the names on the x axis and the dates on the y axis (1996-2002) to show what years each member served. Two questions:

1. Is this possible?
2. What formula do I need to use for the date ranges?
3. How would I even create the chart (what colums I need, etc.)

I hope this makes sense and thanks in advance for your help.

Posted by Steve Hartman on February 04, 2002 10:54 AM

See the tip of the week on the main board. It shows how to do this.