Help with stacked graph and multiple data columns

[maltait]

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]CR - 2016
[/TD]
[TD]AB - 2016
[/TD]
[TD]CR - 2017
[/TD]
[TD]AB - 2017
[/TD]
[TD]CR - 2018
[/TD]
[TD]AB - 2018
[/TD]
[/TR]
[TR]
[TD]Nov
[/TD]
[TD]3711
[/TD]
[TD]2382
[/TD]
[TD]6533
[/TD]
[TD]1344
[/TD]
[TD]6474
[/TD]
[TD]781
[/TD]
[/TR]
[TR]
[TD]Dec
[/TD]
[TD]3218
[/TD]
[TD]1378
[/TD]
[TD]4886
[/TD]
[TD]484
[/TD]
[TD]5370
[/TD]
[TD]671
[/TD]
[/TR]
[TR]
[TD]Jan
[/TD]
[TD]3702
[/TD]
[TD]2004
[/TD]
[TD]5962
[/TD]
[TD]790
[/TD]
[TD]6031
[/TD]
[TD]386
[/TD]
[/TR]
[TR]
[TD]Feb
[/TD]
[TD]3840
[/TD]
[TD]2494
[/TD]
[TD]6132
[/TD]
[TD]601
[/TD]
[TD]6288
[/TD]
[TD]1097
[/TD]
[/TR]
</tbody>[/TABLE]

Hi All,

I’m after some assistance with setting up a stacked graphbut I need 3 columns per each month representing the different years. The stackedgraph is preferred as I’m needing to show answered calls and Abandoned callsgiving the total received when added together.


I’m havingy issues that when I add them they just combine into1 stack. This will be an ongoing reports so after a solution that isn’t timelyand easy to manage JIf there’s a better graph to manage this happy to look at it too. Thanks heapsfor any advice in advance.

 

[bobsan42]

You cannot make this graph natively in Excel AFAIK.
However a small trick can do it for you I think.
Basically you have two data sets to show - CR and AB.
Excel graphs have the ability to show two sets of data on two different value axis - primary and secondary. The bars shown on the secondary are shown on top (or above the bars on the primary axis.
let's say the number of total calls is TC=AB+CR. Basically you have to do is show CR on the secondary axis, and TC on the primary axis, but using a Clustered column layout.

you will have to do some small data adjustment to make it work - instead of AB you will need TC data (AB+CR).
The one thing to be careful about is to set the MAX axis value manually and make it the same for both axis.

(look at an image of the result on the link below)
https://drive.google.com/open?id=1b44en2Wu6GPNyd3L-yY4FXqxija87sIq

Also make sure the gaps and overlapping are the same for all series.

 

[maltait]

Thanks heaps Bobsan42. I'll give that a go