stacked bar chart

J

Jason

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
 
D

Del Cotter

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

Del Cotter

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

Jon Peltier

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
 
J

Jason

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Circular Bar chart? 4
Stacked Bar Chart 1
Adding a line to a population bar chart 0
3D stacked bar and line chart on same graph 2
multi dimension/axis single series bar chart 0
Stacked Chart (per month per year) 1
Stacked Column Charts 2
X-Axis Units Disappear in Stacked Area Chart (Excel 2007) 0

Top