You have to fake the clustered-stacked appearance through careful staggering
of the data:
http://peltiertech.com/Excel/ChartsH...sterStack.html
Then copy the range for the "line", select the chart, and use Paste Special
to add the series as an XY series, with a subtype of lines and markers.
You'll probably have to fudge with the X values and the secondary axes to
make the markers appear where you want them.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"JB" wrote in message
...
I would like to create a combination chart with three chart types:
1. line chart to show month to month accum total growth for the year.
2. a single bar for each month showing the target.
3. a stacked bar for each month showing two actual total comprise of two
sub-groups.
I can not figure how to combine the bars and obtain one stacked bar and
one
single bar. The bars are either all stacked or all single.