Try adding purpose as a dimension to the bar chart to differentiate the counts based on well purpose. Under appearance select the 'Colors by dimension' as well as the 'Stacked' option to change appearance of the bar chart.
Appearance --> Presentation --> Stacked
Appearance --> Colors and Legends --> Custom off --> By dimension
Hope this helps