multiple combination bars chart
 

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....


--
blurboiboi
------------------------------------------------------------------------
blurboiboi's Profile: http://www.excelforum.com/member.php...o&userid=25183
View this thread: http://www.excelforum.com/showthread...hreadid=387947

................................................


--
blurboiboi
------------------------------------------------------------------------
blurboiboi's Profile: http://www.excelforum.com/member.php...o&userid=25183
View this thread: http://www.excelforum.com/showthread...hreadid=387947

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....