Solved

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

Posted on 2014-11-05
5
715 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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

Title # Comments Views Activity
Calculating hours worked based on dates and times from Event logs 2 25
Lookup - Vlookup 9 46
If condition and Date Ranges 13 47
How to always round a decimal up 5 20
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

756 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