Percent comparison chart with more than 100%
I hope I explain this correctly. I am trying to get a stacked chart where my field 'Estimated Hours' = 100% and my 'Actual Hours' is a percentage of 'Estimated Hours'. The Estimated Hours field has different values across the chart so I didn't think they'd all be even at the top. I'd also like to show it where if the Actual Hours is less than the Estimated, that the actual will show as green but if it is more than the estimated, that the amount above the 100% line shows as red. I've tried a few different charts for this. I'm attaching images of what I currently have but I know its wrong. Can someone point me in the right direction?