# How to make an Excel chart change colors, blink, etc.

I have a bar chart with two bars, one for a donation goal, one for the amount donated, pretty basic.

We're having a fundraiser, and I want to show the chart as donations are presented. It works so the donation bar goes up, but I wanted to see if I could do something snazzy, like change colors of the chart when we surpass the goal, or make it flash, or anything to pump up the volume, in an Excel sort of way of course. It's set up to show the donations growing, but I need the snazzy part, if possible.

See attached.
Donations.xlsx
###### Who is Participating?

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Commented:
You can use quasi conditional format (you should use stacked chart, where one part is data below goal and second - equal or over goal). Look at sample
Donations1.xlsx
0

Experts Exchange Solution brought to you by

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

IT SpecialistAuthor Commented:
als315, excellent ! just what to doctor ordered . . . thanks !

but, where is the conditional format ? I'd like to have the Raised amount be red if < 1,000, then yellow if <= 5,000, then green if > 5,000.
0
IT SpecialistAuthor Commented:
Ok, I got the color to be yellow if < 5000 and green if above, but I don't see where the "condition" is . . .

and could I do three levels (red <= 1,000, yellow <= 5,000, green > 5,000 ?

Thx.
0
Commented:
It is "quasi" conditional, so criteria is in formula in D4 and E4. Color is different for parts of stacked bar.
If you like color to be changed at >5000, change D4 from
=IF(\$C4<\$C\$9,\$C4,NA())
to
=IF(\$C4<=\$C\$9,\$C4,NA())
and E4 from
=IF(\$C4>=\$C\$9,\$C4,NA())
to
=IF(\$C4>\$C\$9,\$C4,NA())
Any new color require new column of data.
Donations1.xlsx
0
IT SpecialistAuthor Commented:
Ok, excellent !

I'll try a new color for three levels myself, and post another question as needed.

Thx !
0
###### It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.