Combination charting with two axis

  • Thread starter Thread starter JB
  • Start date Start date
J

JB

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.
 
You have to fake the clustered-stacked appearance through careful staggering
of the data:

http://peltiertech.com/Excel/ChartsHowTo/ClusterStack.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
 
Back
Top