stacked column combination

[nellie]

I would like to create a chart with 2 sets of stacked columns side by side over a five year time span. I have managed by using two axes to get one set pf stacked columns to the left axis and one set to the right axis - but I now need to separate them (the stacked columns are on top of each other) - any ideas or should I try something different..

 

[Tushar Mehta]

For one possible solution, check funchrt4.zip from Stephen Bullen's
site at http://www.bmsltd.co.uk/excel/SBXLPage.asp#Charting

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Jon Peltier]

Or adopt the technique on this page to offset the series:

http://www.geocities.com/jonpeltier/Excel/Charts/format.html#Col2Axes

- Jon

 

[Nellie]

Thankyou Tushar and Jon,

The Stephen Buller example was just what I needed. Now I might just switch the axes around (he has the blank series for the x axis lables on the primary axes and the data on the secondary axes which can get a bit confusing if the scales change!).

I will add Stephen Bullers website to my favourites as well as Jons in case I have chart queries again.

Nellie