Multiple Stack Up Chart

  • Thread starter Thread starter ERIC
  • Start date Start date
E

ERIC

I have a problem on creating a stack up chart :
__A__ __B__ __C__ __D__
01/02/04 12 23 32 23
02/02/04 32 12 56 56

On the X axis is the Date. A and B is belong to 1 group,
therfore i need them to stack up wherelse C and D form
another one.These 2 stack up bar group are under x
axis "01/02/04"

Thanks for the help!!
 
Eric -

Stagger your data:

__A__ __B__ __C__ __D__
01/02/04 12 23
01/02/04 32 23
02/02/04 32 12
02/02/04 56 56

To improve the appearance, set the gap width of the series to zero, and
incorporate some blank rows in the data:

__A__ __B__ __C__ __D__
<blank row>
01/02/04 12 23
01/02/04 32 23
<blank row>
02/02/04 32 12
02/02/04 56 56
<blank row>

This doesn't work with a time scale X axis, only with a category axis.
Change this through Chart Options on the Chart menu, the Axes tab.

For more about stacked-clustered charts, see the details at Stephen
Bullen's site:
http://www.bmsltd.co.uk/Excel/SBXLPage.asp#Charting
and look at the description for FunChart4

or at Bernard Liengme's site:
http://www.stfx.ca/people/bliengme/ExcelTips/Columns.htm

- Jon
 
Back
Top