Adding Total Bar

To display a stacked bar chart with an additional bar showing the total. A way round this problem is to change the chart type to stacked and create another series.
Make the bars white and then have the white bars with the coloured bars stacked on top.