plot range bar chart
 

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).

plot range bar chart
 

Hi,

You should be able to use the techniques used to build a gantt chart.
http://pubs.logicalexpressions.com/P...cle.asp?ID=343

Cheers
Andy

kh wrote:
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).

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info