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.
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.