View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Frankgjr
 
Posts: n/a
Default colors of bar charted data don't follow data after sorting

I created a bar chart that has 14 variables. I changed the color of 2 bars to
yellow, 5 bars to blue, and 6 bars to red. When new data is ploted and sorted
in a desending order. the colored bars don't follow the variable, they stay
in their original location. I have to manualy change the colors to match my
ledgend.