multiple combination bars chart

[blurboiboi]

possible to have the above mentioned?..

for example I have 4 shops.... each shop has a Total Sales figure and
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 Sale
figure for each of the 4 shops (represented by 4 different colours)
Now the diff part is whether for the Cash Sales Figure... is i
possible to integrate into each of the 4 bars represented by another
different colours??.. Desired outcomes: 4 bars each month with
different colours...

 

[Jon Peltier]

Something like this?

http://peltiertech.com/Excel/ChartsHowTo/ClusterStack.html

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