My chart is referencing data in a filtered list. When I change the list, my chart changes. I have colored the data points in my chart not because of specific values by based on the ordering (first six items are blue, the next six are green, the next two black, the next two yellow, etc). This functionality worked in excel 2007 but now when I change the filtered list, they coloring disappears. I have also gone through all the different filtered items and change those colors, but when I switch the filters...they are gone. I am potentially looking for a macro that will apply my colors to these data items as I believe from reading in other posts that this is a known excel issue. Please help. I have included a simple example of what I am talking about. It works as it should, but in my live example which has more moving parts...it works then it doesn't. It is inconsistent and I need to rely no a solution.