plot range in excel chart

[kh]

How do I plot a range in a bar chart? I would like to list names on one axis
and years on the other. Then I want to plot their years of service.

For example:

If John Doe served from 2005 - 2007, I want the chart to show that range,
but not before or after.

Below John I have Jane Doe who served from 2001-2006.

The chart, then would have an overall range of 2001-2007.

Maybe a bar chart isn't the correct one (it will only "start" data at the
starting point - 2001).

 

[Pete_UK]

Maybe a Gantt chart might be more appropriate. Jon Peltier shows how
to construct one here:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=343

Hope this helps.

Pete

 

[Shane Devenshire]

Hi,

If you are using 2003 or earlier, you could select your data and click the
Chart Wizard, choose Custom Types, Floating Bar