how to make a scale-like plot of job positions

[chapkovski]

Hello!
I've got a problem of plotting the "scale"-like scale of a person's career. Every job position a person has had has a certain rank (for instance, junior manager is 0, CEO is 21 - the highest position).
So my task is to plot months in a certain rank against the rank, like this:

the problem is that I have a table with the fields like (Position);(Beginning of the job);(End of the job);(Position rank). And I do not know the way how to do it not manually (as I did in the file here). And there are PLENTY of the people I have to make plots like this...(((
any ideas?

 

[AlphaFrog]

Here's a very good step-by-step tutorial by Jon Peltier

Step Charts in Microsoft Excel

 

[chapkovski]

Here's a very good step-by-step tutorial by Jon Peltier

Step Charts in Microsoft Excel

Thank you very much! That's what I need!