Something like this?

http://peltiertech.com/Excel/ChartsH...sterStack.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

blurboiboi wrote:

possible to have the above mentioned?..

for example I have 4 shops.... each shop has a Total Sales figure and a
Total Cash Sales Figure...

Y axis would be the number.... X axis would be the month... Jan, Feb,
Mar....Dec...

so for each month there would be 4 vertical bars showing Total Sales
figure for each of the 4 shops (represented by 4 different colours).
Now the diff part is whether for the Cash Sales Figure... is it
possible to integrate into each of the 4 bars represented by another 4
different colours??.. Desired outcomes: 4 bars each month with 8
different colours....