stacked bar chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
installed refresh refresh
pc1 2002 2006 2010
pc2 2003 2007 2011
pc3 2002 2006 2010
Click to expand...
No matter how i create the chart it is always starts with 1905.
Click to expand...

Look up "Chart Axes, scale", or similar in the Excel help file. It will
show you how to set the axis scale so that it starts with 2000 instead.
 
Jason said:
Look up "Chart Axes, scale", or similar in the Excel help file. It will
show you how to set the axis scale so that it starts with 2000 instead.
Click to expand...

You also have a more serious problem: the data you have entered for the
stacked bar chart implies that pc1 was installed in the year 2002,
refreshed 2,006 years later, and refreshed again 2,010 years after that.
 
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
 
Another question..

I wish to have 2 stacked bars for each Y-axis.

eg.

installed refresh refresh
pc1 2002 4 4
ups1 2003 4 4

pc2 2003 4 4
ups2 2004 4 4

What can I do? I have tried several options but unsuccessful.

many thanks.

Jason.
 
Back
Top