View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Combination charting with two axis

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.