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