Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
................................................ -- blurboiboi ------------------------------------------------------------------------ blurboiboi's Profile: http://www.excelforum.com/member.php...o&userid=25183 View this thread: http://www.excelforum.com/showthread...hreadid=387947 |
#3
|
|||
|
|||
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.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Bars in a chart??????? | Excel Worksheet Functions | |||
How to lock combination chart in pivot chart? | Charts and Charting in Excel | |||
How to change Series order in a Combination Chart? | Charts and Charting in Excel | |||
How to change Series Order in a Combination Chart? | Excel Discussion (Misc queries) | |||
bar chart with multiple legends? | Charts and Charting in Excel |