Can I combine a stacked and clustered column chart in Excel   

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.

date: Wed, 4 May 2005 07:30:16 -0700   author:   Tim Donnelly Tim

RE: Can I combine a stacked and clustered column chart in Excel   

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. 

"Tim Donnelly" wrote:

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

date: Wed, 4 May 2005 09:08:06 -0700   author:   bj

Re: Can I combine a stacked and clustered column chart in Excel   

Tim -

Try any of the links on this page:

   http://peltiertech.com/Excel/ChartsHowTo/ClusterStack.html

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

Tim Donnelly wrote:
> 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.

date: Sat, 07 May 2005 10:32:32 -0400   author:   Jon Peltier

RE: Can I combine a stacked and clustered column chart in Excel   

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.

"bj" wrote:

> 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. 
> 
> "Tim Donnelly" wrote:
> 
> > 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.

date: Tue, 6 Oct 2009 13:21:28 -0700   author:   adamtaylor356

Re: Can I combine a stacked and clustered column chart in Excel   

I've written a tutorial on this type of chart:

Clustered-Stacked Column Charts - 
http://peltiertech.com/WordPress/clustered-stacked-column-charts/

The tutorial was based on Excel 2003, but the steps in 2007 are not 
different, just the places you have to hunt to find the commands are. In 
the comments I spelled out the protocol for 2007.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



adamtaylor356 wrote:
> 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.
> 
> "bj" wrote:
> 
>> 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. 
>>
>> "Tim Donnelly" wrote:
>>
>>> 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.

date: Tue, 06 Oct 2009 16:56:54 -0400   author:   Jon Peltier

Re: Can I combine a stacked and clustered column chart in Excel   

Excel 2007 Chart
Stacked and clustered columns.
Using superimposed charts.
http://www.mediafire.com/file/lnzwmz03umj/10_06_09a.xlsx

date: Tue, 6 Oct 2009 17:07:56 -0700 (PDT)   author:   Herbert Seidenberg

Re: Can I combine a stacked and clustered column chart in Excel   

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.

"Jon Peltier" wrote:

> I've written a tutorial on this type of chart:
> 
> Clustered-Stacked Column Charts - 
> http://peltiertech.com/WordPress/clustered-stacked-column-charts/
> 
> The tutorial was based on Excel 2003, but the steps in 2007 are not 
> different, just the places you have to hunt to find the commands are. In 
> the comments I spelled out the protocol for 2007.
> 
> - Jon
> -------
> Jon Peltier
> Peltier Technical Services, Inc.
> http://peltiertech.com/
> 
> 
> 
> adamtaylor356 wrote:
> > 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.
> > 
> > "bj" wrote:
> > 
> >> 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. 
> >>
> >> "Tim Donnelly" wrote:
> >>
> >>> 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.
>

date: Wed, 7 Oct 2009 10:00:01 -0700   author:   adamtaylor356

Re: Can I combine a stacked and clustered column chart in Excel   

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
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



adamtaylor356 wrote:
> 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.
> 
> "Jon Peltier" wrote:
> 
>> I've written a tutorial on this type of chart:
>>
>> Clustered-Stacked Column Charts - 
>> http://peltiertech.com/WordPress/clustered-stacked-column-charts/
>>
>> The tutorial was based on Excel 2003, but the steps in 2007 are not 
>> different, just the places you have to hunt to find the commands are. In 
>> the comments I spelled out the protocol for 2007.
>>
>> - Jon
>> -------
>> Jon Peltier
>> Peltier Technical Services, Inc.
>> http://peltiertech.com/
>>
>>
>>
>> adamtaylor356 wrote:
>>> 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.
>>>
>>> "bj" wrote:
>>>
>>>> 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. 
>>>>
>>>> "Tim Donnelly" wrote:
>>>>
>>>>> 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.

date: Thu, 08 Oct 2009 15:17:05 -0400   author:   Jon Peltier