How do you make the colors represented by each series consistent for like data in multiple indicators? In other words, chart 1 lists all the cities in a state by population and the bar for New York is blue. In chart 2, the top ten cities with the largest population are listed. The bar for New York is a different color. Is there an easy way to make both charts show the same color for New York?