krishnak
09-15-2010, 04:33 PM
Hi All,
In the attached Excel workbook, I have three columns - PlCode, AvgReliability, Profile. I have drawn the column chart using the first two column values - PlCode and AvgReliability. That is quite simple.
Now keeping this chart intact, I want to apply different colors to the bars depending to which Profile each bar belongs (third column of the worksheet). If the Profile is A, I want the corresponding chart columns to show in Red, Profile B in Blue, Profile C in Yellow and Profile D in Green.
For example, the first bar (PL 103) should show in Red color (Profile A), the second bar (PL 046) should show in Blue color and so on.
How can I do it either manually or by VBA?
Thanks in advance for any suggestions.
In the attached Excel workbook, I have three columns - PlCode, AvgReliability, Profile. I have drawn the column chart using the first two column values - PlCode and AvgReliability. That is quite simple.
Now keeping this chart intact, I want to apply different colors to the bars depending to which Profile each bar belongs (third column of the worksheet). If the Profile is A, I want the corresponding chart columns to show in Red, Profile B in Blue, Profile C in Yellow and Profile D in Green.
For example, the first bar (PL 103) should show in Red color (Profile A), the second bar (PL 046) should show in Blue color and so on.
How can I do it either manually or by VBA?
Thanks in advance for any suggestions.