I am using a stacked column chart to achieve an effect requested by a user. They are wanting to see a breakdown of percentages per group that is bringing them below a particular target. I am "lifting" the smaller percentages represented on the chart "up" by setting the opacity for a particular series to 0 (zero). My problem is that they want the chart scaled from 60-100% but the smaller percentages that I am "lifting up" with the hidden series are not being displayed, because their value is less than 60.
I've attached three files to show the problem I am having:
- ChartNoHide.jpg displays the hidden series that is used to lift up the smaller percentages.
- ChartHide.jpg displays the way they want it displayed except it is scaled from 0-100%
- ChartProb.jpg displays how it is displayed when the .Min is set to 60 (.Min(60))
Any help would be appreciated.
I've attached three files to show the problem I am having:
- ChartNoHide.jpg displays the hidden series that is used to lift up the smaller percentages.
- ChartHide.jpg displays the way they want it displayed except it is scaled from 0-100%
- ChartProb.jpg displays how it is displayed when the .Min is set to 60 (.Min(60))
Any help would be appreciated.