Conditional Formats in Charts

Hi,
there are solutions at Jon Peltier's site

I cant seem to apply that to these charts..

Any solution at all?

Hi Andy,

Thank you for replying.

Would it be possible for you to show me the starting script(s) to the macro?

very nice sir...very nice! thank you so much for your help Andy

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

Hi Andy, thank you for your help so far, I really appreciate it.

I have tried tweaking the macro a bit to show the expenses are red if they exceed the income...I am unable to do so for both sides?

Any suggestions?

thank you

Well I was trying to change the columns that go red, the switch between red and black.

I have tried entering 'Green' where it says 'Red' (in the macro) I have tried:

With ActiveSheet.ChartObjects(1).Chart
' make both bars the same
.SeriesCollection(2).Format.Fill.ForeColor.RGB (155,0,2) = .SeriesCollection(1).Format.Fill.ForeColor.RGB (160,8,5)

Just random colours for now, but the columns that I wanted to change weren't changing..

that is changing the colour for the Income column.

I wanted to make the 'Expense' column (Which currently switches between Red and black) to follow the conditional format that I had set in cells B32, C32and B33, C33

Maybe I didn't explain myself properly..sorry

that's very good Andy, you are too good!

but its when 'Mr A's' expenses are greater than his income, the expenses stay green...so its kind of inverted.

Again I have tried, and that doesn't work

This is what I am after.

MR A Columns

Income = $60,000
Expense = $61,000

Then expense column goes red.

Income = $60,000
Expense = $60,000 (or below)

the expense column stays green...

Is there a code for that?

Cool.

Thanks

I will have to play around with this a little bit. Somehow, I dont see what I want (you have done great) I need to re-do the conditions.

I wanted it to turn out the opposite to what it is now..

If the income is less than the expenses then both columns should be red

If the income is more then both columns can be green...?

Does that make sense to you, any suggestions on how I can improve this?

Thank You

Great I will be testing this out shortly.

One last query, is it possible for these graphs to change colour automatically?

i.e. is there a non-macro way to do this?

Because I will want to present 2 versions, one with a macro and one without a macro...

Andy, I really appreciate your assistance.

Amazing! You are a genius.

Thank you for all your efforts I now have both graphs going well and that is all thanks to you.

How do I add you in my list? If thats ok with you.