Pareto Chart Colors

[scott micklo]

hi

I have been able to make a Pareto chart and its got neat bells/whistles on it.

But one question for the master:

My bars on the chart is graphing 2 items for each category (1 processed; 1 unprocessed). In my headers on my table, I have them color coded for easy recognition. Is there a convenient way (NOT going into each bar and changing the color) for the graph to show which category (processed/unprocessed) its representing.

Thanks in advance..........

[Kaper]

Probably you will need a macro, which goes through all series on the graph and makes appropriate changes to each bar interior. if thats tough - attach representative sample file (workbook, not just picture) with as-prrepared graph, and a copy of the graph with hand adjusted colors.