I have the attached Document which shows a a stacked bar chart using the chart wizard and another chart underneath showing the chart I wish to have but not sure it is possible.
Basically I want two values to be on the one bar chart, so the sum of VisitCount will always be higher than the the set analysis expression of FTF, if both values are the same then I would like the values to be the sum of the VisitCount and the bar to show as blue.
I hope I've explained myself clearly but you can see from the attached document the difference of where the total value of the single bar is different.
So you can take "Values on Data Points" off and I would expect to see the below percentages for FTF:
Phil King - 28.57%
John Smith - 50.00%
Steve Jones - 20.00%
Barry Smith - 0.00%
Tom Jones - 100.00%