Solved

Need help with Excel chart, changing colors under three conditions

Posted on 2014-11-07
2
212 Views
Last Modified: 2014-11-07
I got great help from EE here, to get a donation "thermometer" bar chart, to change colors on the donations bar if donations exceeds the goal.

I'd like to have three colors:
- Red if under $2,000
- Yellow if under $5,000
- Green if over $5,000

see attached for the yellow and green part.
Donations-EE.xlsx
0
Comment
Question by:Gadsden Consulting
2 Comments
 
LVL 25

Accepted Solution

by:
ProfessorJimJam earned 500 total points
ID: 40429750
hey, please find attached.

it has a worksheet event vba code. so it works with vba enabled.
Donations-EE.xlsm
0
 

Author Comment

by:Gadsden Consulting
ID: 40429788
Fantastic ! Works great . . .

Thank you :-)
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

867 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now