Solved

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

Posted on 2014-11-05
5
700 Views
Last Modified: 2014-11-06
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
Comment
Question by:Gadsden Consulting
  • 3
  • 2
5 Comments
 
LVL 39

Accepted Solution

by:
als315 earned 500 total points
ID: 40425822
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
 

Author Comment

by:Gadsden Consulting
ID: 40426231
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
 

Author Comment

by:Gadsden Consulting
ID: 40426289
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
 
LVL 39

Assisted Solution

by:als315
als315 earned 500 total points
ID: 40426903
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
 

Author Comment

by:Gadsden Consulting
ID: 40426937
Ok, excellent !

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

Thx !
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is the result of a quest to better understand Task Scheduler 2.0 and all the newer objects available in vbscript in this version over  the limited options we had scripting in Task Scheduler 1.0.  As I started my journey of knowledge I f…
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question