Stacked bar to create a type of timeline chart

[jerH]

I have a bunch of chronological data about people occupying various leadership positions in an organization. What I'd like to create is a chart where each "bar" corresponds to a position and the "pieces" that are stacked in that bar represent the tenures of the individuals who have occupied the position. There are 5 positions we're interested in, so there should be 5 bars. I'm sure this is a simple matter of formatting the data correctly, but so far on this Monday I've been unable to hit on an easy method.

The data looks something like this:

Position 1	Start Date	Duration
Padding	9 March 1946	566
Bob	26 Sep 1947	216
Chuck	30 Apr 1948	1886
Tom	30 Jun 1953	1461
etc	etc	etc

Position 2	Start Date	Duration
Padding	9 March 1946	558
Bill	18 Sep 1947	949
Sam	24 Apr 1950	1002
Joe	4 Feb 1953	920
etc	etc	etc

The padding entry is just to provide a common start to all the positional series....9 March 1946 is the earliest start date from the 6 series.

If this isn't clear please let me know and I can try to elaborate.

Thanks!

[jerH]

Timeline.jpg

Hopefully this clarifies...each colored bar portion would correspond to a different individual....

[Andy Pope]

You need to alter you data layout

[jerH]

You need to alter you data layout

Many thanks!