Vertical stacked bar charts in Excel

Hi. I've created this chart in Excel and want to make the entries in the legend appear in the same order top to bottom as they are in the chart (the legend reads A to D from the top but the bar...