Hi,

There's a thing called 'Columns and Lines' at
http://www.edferrero.com/charting.aspx that may do what you want.

Ed Ferrero

What I need is cluster STACED bar graphs.  Those examples seem to be
just cluster bars and line charts.

I figured a way to do it by charting all the stacked bar data first and
then adding a new series, changing that to the 2ndary axis, and
changing that chart type to line.

However, the line doesn't plot in the middle of the stacked cluster
bars.

Does anyone have any ideas how to adjust the positioning of the line
part of the graph?  Since I only have 2 stacked bars in each cluster,
it seems I'm forced to plot the line with either the 1st or 2nd bar.

Thanks!

What I need is cluster STACKED bar graphs.  Those examples seem to be
just cluster bars and line charts.

I figured a way to do it by charting all the stacked bar data first and
then adding a new series, changing that to the 2ndary axis, and
changing that chart type to line.

However, the line doesn't plot in the middle of the stacked cluster
bars.

Does anyone have any ideas how to adjust the positioning of the line
part of the graph?  Since I only have 2 stacked bars in each cluster,
it seems I'm forced to plot the line with either the 1st or 2nd bar.

Thanks!

Thanks for the website. Nice instructions.

A couple issues for me.

1.  I want STACKED cluster bars.  The examples all are solid bars.  I
think the general same strategy works, though.  You just need to start
off with a stacked bar cluster chart and convert some of the series to
lines.  You can fill in the gaps with =N/A() to connect the lines.

2.  If you have an even number of bars, you can't make the lines fall
in between the bars (as far as I can tell).  Maybe someone has figured
out a way to insert a dummy series between the real ones so the line
can match that one?

Thanks!