You can select the pipeline series and change the chart back to stacked.
What I can't quite understand is what you want it is stacked with???

Cheers
Andy

Benjamin B wrote:
Andy,

Thanks. However, the pipeline data still looses it's stacked bar format.
Any hints on how to convince excel to leave all data series as stacked?

"Andy Pope" wrote:


Hi,

Try staggering you data and then create you stacked chart and move
Pipeline to the secondary axis.

Yr 1 YR 2 Pipeline
Small 7 1
Deals 13
Med 2 6
Deals 14
Large 0 2
Deals 20

Cheers
Andy

Benjamin B wrote:

Need to create a stacked bar chart and utilize the secondary axis for data
with a different value range.

Data Table:
Yr 1 YR 2 Pipeline
Small Deals 7 1 13
Med Deals 2 6 14
Large Deals 0 2 20

Primary axis should be Yr 1 & 2 and secondary axis should be pipeline.
Having created the stacked bar chart I change the pipeline series to the
secondary axis and end up with a simple bar chart. How can I create a
stacked bar chart with a secondary axis with a different scale?

Thanks.





--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info