try moving the data for the pipeline series down far enough that it does not
overlap the other data.make a stacked column chart
select each of the data sets shown in the pipeline set and change to
secondary axis. (you may have to play with the scale to be able to select
each of them) It will probably strart to show as a side by side chart and you
will have to select one and set it as chat type stacked columns again. By
playing with the fill and line formating you can easily indicate which side
should be used for value axis a,d which legend character you want.
I would select the unwanted legend charaters in the legend box and clear all
so that they dont show
"Benjamin B" wrote:

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.