• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 792
  • Last Modified:

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
0
Gadsden Consulting
Asked:
Gadsden Consulting
  • 3
  • 2
2 Solutions
 
als315Commented:
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
 
Gadsden ConsultingIT 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
 
Gadsden ConsultingIT 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
 
als315Commented:
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
 
Gadsden ConsultingIT SpecialistAuthor Commented:
Ok, excellent !

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

Thx !
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now