stacked with 2nd axis as line (%)

Please see attached for data layout

I want to stack bar chart columns H & I
with secondary axis (line chart) for column J as line with data points

Using Excel 2007.

I can get stacked bar fine
I can get secondary axis for %
but I can't convert secondary data to line chart. It says it is a line chart, but when using data points it only shows points (as shape of X's) but no lines.

I tried an alternate method of inserting blank line below each 'name' and only having in that row the value for ss%, but remove it from line above. This is how I could get secondary Axis but again no line chart. Stacking again is what I expect. =\

Frustrated with Excel 2007 layout...

Sorry, Getting used to this site and failed to notice the file was too large before... Reformatted to JPG.

Thanks

Originally Posted by SidCharming

Sorry, Getting used to this site and failed to notice the file was too large before... Reformatted to JPG.

Thanks

Hey - I had the same challenge, so nice one with the stacked histogram and line on the second y axis . I used your xls file and substituted the data with my own data.

But still not sure how to create one from scratch - how did you do it?!?

I'd love to hear back from you

Okay I feel embarrassed, b/c in the process of gathering data to put chart together, this time (one of MANY) it worked as expected... I am sharing my output so if someone has questions this should answer.

THANKS for the push which resulted in getting the outcome I expected.