Re: Bar Chart: Conditional formatting
As Andy Pope has written elsewhere on the forum, conditional formatting on charts is very limited. My first thought to apprach your problem, is to change the appearance of the chart using vba. To record some code, use the macro recorder. You just record while you manually change the color of say a bar chart. Then go to the code in the modules in VBA. What you then have to do is, I'm just thinking loudly, substitute in the conditions you used in the conditional formatting, based on the cell values. That is, you use 1 or more ifs to assign for instance the color of a bar chart. The conditions are those you used in the conditional formatting as well. Merry Christmas to you too David. Let us know if you proceed.
Last edited by Wigi; December 23rd, 2005 at 02:21.
Excel MVP 2011, 2012, 2013
-- Please use a meaningful title for your topic --