Solved

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

Posted on 2014-11-05
5
709 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 40

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 40

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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
: Microsoft Office Collaborate for free and online versions of Microsoft  Word, Excel, Powerpoint, OneNote, Onedrive , Email, Calendar etc. In short we can say that Microsoft office is a suite of servers, applications and services developed by  Micr…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

828 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