Can I combine a stacked and clustered column chart in Excel

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

Guest

I would like to have two columns on the same chart. One will be the amount
of good parts produced by a machine. The other would be a stacked column of
scrap parts produced by the machine. The scrap parts are seperated by
certain defects, but I'd like to see their total compared to the total of
good parts.
 
a sort of sneaky way to do it is to set all of the data up with a blank cell
between the machine data indicators.
make a stacked chart of all of the data including the good parts.
select the good part section and change the axis to secodary axis.
then goto <chart><source data><series and change the range for the good
parts up or down one cell to move it on the chart.
This will allow you to have different scales for the good and bad parts.
If you want then to have the same scales another way to do it would be, if
your data is in columns to alternate the good data in one column and all of
the other data in the next column. Then just mnaking a stacked column chart
would do what you want.
 
I've got a similar problem. I'm graphing renewable water production versus
consumption in a building. We have 4 different sources of production and 1
source of consumption. I'd like to have a chart comparing production and
consumption each month with the production column broken down by each source.
I've tried the trick you mentioned, but the column for the water consumption
always apears overlapping the production column.

I tried setting my production range to numerals for each month (1=jan,
etc...) and setting the consumption to half numerals (1.5=jan, etc...) but
the consumption column still overlaps the production column.

Also, I'm using Office 2007, so try to respond using 2007 steps.
 
That tutorial was exactly what I needed. I've seen other replies directing
people to your cluster-stacked utility, but (no offense) I'm not going to
spend money on a utility I'm only going to use this one time on this one
report. Thanks for the tutorial though. It helped a lot.
 
Adam -

The utility is for people who can't be bothered to follow a tutorial, or
who have many charts to do. The tutorial is for industrious folks who
don't mind a challenge.

- Jon
 
Back
Top