Excel 365 bar chart: unable to vary bar colors for series and category order is reversed

Using Excel 365

Attached is a spreadsheet that shows the chart I am working with. I have two questions:
1) how can I make the bar colors vary for the data series "Dollars"?
2) how can I reorder the category "Region" to be in alpha order (see where the data is in alpha order, but on the chart it is in reverse alpha order)? The data to the left of the charts shows: Central, East, North, but the chart shows North, East Central.

Thank you