BJ,

Yes. The series "Year 1" deals should be stacked then next to that would be
the "Year 2" series stacked, followed by the "Pipeline" series stacked.



"bj" wrote:

do you want the three items to still in in one stack?
or do you want the pipeline to be besides the yr1 and yr2 data.
I am not sure what you want to do.

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