1. Don't try to format your years as dates, because 2002 is Excel's internal
code for 24-Jun-1905 (i.e., day number 2002 after 1-Jan-1900).

2. The stacked parts of the bars need to show only the difference between
the new date and the old date:

PC1 2002 4 4

3. Use a regular stacked bar chart type, not the floating bar chart in the
Built-In Custom collection. (With a name like "Built-In Custom", it can't be
good; anyone remember "mangled baby ducks"?).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______



"Jason" wrote in message
...
I wish to create a horz. stacked bar chart for PC refresh cycles. (unit in
years)
sample data:
installed refresh refresh
pc1 2002 2006 2010
pc2 2003 2007 2011
pc3 2002 2006 2010

x: axis = years
y: axis = pc1,2 ,3...etc

No matter how i create the chart it is always starts with 1905.
is there anyway I can create a cimple and easy chart? maybe something
similar to grantt chart.

many thanks.

Jason