Help with stacked graph and multiple data columns

maltait

New Member
Joined
Feb 2, 2015
Messages
12
Office Version
  1. 2016
[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.

 

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.
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.
open
(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.
 
Upvote 0

Forum statistics

Threads
1,223,911
Messages
6,175,335
Members
452,636
Latest member
laura12345

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top