http://peltiertech.com/Excel/Charts/...olAndLine.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


wrote in message
oups.com...
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!