Conditional Formatting a Chart & Ordering from High to Low

Hello,

I have some simple data that I am trying to display in a bar chart. I have a number of people who's sales I am tracking from week to week. I would like to be able to simple enter the data into one table and have charts that automatically format the way I'd like.

I want the people with the highest sales on top and those with the lowest sales on bottom. I know I can achieve this by sorting the data each time, but is there a way to do it from the chart and not changing the original data?

I would also like to color-code the graph so that sales of 6 and below are red, 7 through 9 are yellow, and 10 and above area green.

I've attached an example worksheet. The Week 1 Chart was created manually by copying the data from the main table and coloring the graph individually, but this is an example of how I would like the other charts to format automatically.

Any ideas and/or suggestions would be very much appreciated!

Thanks in advance!