Help with stacked graph and multiple data columns

maltait

New Member
Joined
Feb 2, 2015
Messages
7
CR - 2016
AB - 2016
CR - 2017
AB - 2017
CR - 2018
AB - 2018
Nov
3711
2382
6533
1344
6474
781
Dec
3218
1378
4886
484
5370
671
Jan
3702
2004
5962
790
6031
386
Feb
3840
2494
6132
601
6288
1097

<tbody>
</tbody>

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.

 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

bobsan42

Well-known Member
Joined
Jul 14, 2010
Messages
1,343
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,614
Messages
5,523,902
Members
409,542
Latest member
Shezz01

This Week's Hot Topics

Top