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...![]()
Bookmarks