Excel - Trying to apply conditional formatting to bars in bar charts

baxy · Joined: 28 Aug 2003 Posts: 207

I have installed asap utility and now I make conditional formatting. But I wonder is there any way to apply conditional formatting to bar in charts. I have to admit that I never tried this. You will probably say that I should, but If you know how to do, I kindly ask for explanation.

gaston · Joined: 20 Mar 2004 Posts: 190

To apply conditional formatting to bar in charts first remove the original data; after that check if chart is a stacked column type (not a clustered column type); after that go to chart menu, select chart type, select second column chart option and fill bar with wanted color. This is whole procedure!

H-Desk.com - PC Security matters - Protect your PC privacy

Excel - Trying to apply conditional formatting to bars in bar charts

LIFEFORM SOCIAL COMMUNITY NETWORK