Double combo charts - are they possible?
 

I have a set of data: 4 columns columns are categories: DSD, 3PL, DCs, and
Totals) by 5 rows (rows are years 2005 - 2009).
I have successfully created a combo chart to show the first 3 columns as
bars and the 4th (totals) as a line.

I also have a nother chart (essentially the components of DCs) in a stacked
column. My question is this:

Can I have the side by side charts by year with one of those data series a
stacked column AND the line for the totals all on the same graph.

If you need a sample file, I have one with both graphs and data already
completed.

Any help would be appreciated.

Steve -

You can make all manner of combination charts, especially once you know how to do
your own. The built in examples are rather limiting.

Chart all your data as stacked columns. Select the series you want as a line, choose
Chart Type from the Chart menu, and select a line style that you like.

There, a custom combination chart.

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

Steve wrote:

I have a set of data: 4 columns columns are categories: DSD, 3PL, DCs, and
Totals) by 5 rows (rows are years 2005 - 2009).
I have successfully created a combo chart to show the first 3 columns as
bars and the 4th (totals) as a line.

I also have a nother chart (essentially the components of DCs) in a stacked
column. My question is this:

Can I have the side by side charts by year with one of those data series a
stacked column AND the line for the totals all on the same graph.

If you need a sample file, I have one with both graphs and data already
completed.

Any help would be appreciated.

Thanks, Jon...but I went to your website and I found the one that I wanted to
do through one of the links posted there.

http://www.stfx.ca/people/bliengme/E...ps/Columns.htm

Thanks again

"Jon Peltier" wrote:

Steve -

You can make all manner of combination charts, especially once you know how to do
your own. The built in examples are rather limiting.

Chart all your data as stacked columns. Select the series you want as a line, choose
Chart Type from the Chart menu, and select a line style that you like.

There, a custom combination chart.

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

Steve wrote:

I have a set of data: 4 columns columns are categories: DSD, 3PL, DCs, and
Totals) by 5 rows (rows are years 2005 - 2009).
I have successfully created a combo chart to show the first 3 columns as
bars and the 4th (totals) as a line.

I also have a nother chart (essentially the components of DCs) in a stacked
column. My question is this:

Can I have the side by side charts by year with one of those data series a
stacked column AND the line for the totals all on the same graph.

If you need a sample file, I have one with both graphs and data already
completed.

Any help would be appreciated.