Dynamic Stacked Column Chart

becklog

New Member
Joined
Dec 26, 2016
Messages
38
Hi,

I am running out of ideas how to do this. I can do it using a regulart column chart but not on a stacked column.

I have a table. A2:A10 for the type of issues B1:F1 are resolutions and B2:F10 are the counts of each actions based on the issue. I want to do a stacked column chart to show the breakdown of the actions taken per issue however if the issue and resolution is equal to 0, I dont want to show it in the chart. I already tried assigning name ranges on both series and category but still not getting the desited output. Any help?

PS: macro or named range or formula will do.
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Forum statistics

Threads
1,213,490
Messages
6,113,957
Members
448,535
Latest member
alrossman

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