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
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______
> I have a problem on creating a stack up chart :
> __A__ __B__ __C__ __D__
[quoted text clipped - 7 lines]
>
> Thanks for the help!!