Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Simple Dashboards???
I want to use plain bar charts but I want the color to change from red to
yellow to green as the number increases. For example, if a rep made 15 calls that day then the bar would go slightly up and it would be RED. If the rep mad 30 calls then the bar would of course go up a little higher and it would become YELLOW. If ther rep made 45 calls or more then the bar would of course go up higher and become GREEN. Is this possible? If so, how do I do it? |
#2
|
|||
|
|||
This website may help you out:
http://peltiertech.com/Excel/Charts/...nalChart1.html tj "Jared_Hmr" wrote: I want to use plain bar charts but I want the color to change from red to yellow to green as the number increases. For example, if a rep made 15 calls that day then the bar would go slightly up and it would be RED. If the rep mad 30 calls then the bar would of course go up a little higher and it would become YELLOW. If ther rep made 45 calls or more then the bar would of course go up higher and become GREEN. Is this possible? If so, how do I do it? |
#3
|
|||
|
|||
This can be done with 3 formulas and a chart.
Assume your names are in A3:A10 Assume your sales are in B3:B10 Creater a table that kinks to this data by putting names again in say D3:D10 (use links if you want the names to change automatically) Lets assume the breaks were 30 (RED), 70 (YELLOW) and above 70 is (GREEN) In E3 put =MIN(B3,30) In F3 put =MIN(B3,70)-E3 In G3 put =MAX(0,B3-SUM(E3:F3)) Copy E3:G3 down to E10:G10 Select D3:G10 and hit the chart button and choose a stacked bar graph. Now clear the legend and then just format the colours accordingly, which you will only have to do once. Regards Ken................ "Jared_Hmr" wrote: I want to use plain bar charts but I want the color to change from red to yellow to green as the number increases. For example, if a rep made 15 calls that day then the bar would go slightly up and it would be RED. If the rep mad 30 calls then the bar would of course go up a little higher and it would become YELLOW. If ther rep made 45 calls or more then the bar would of course go up higher and become GREEN. Is this possible? If so, how do I do it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
New Excel user needs help with simple Macro... | New Users to Excel | |||
Ploting dates against a calendar and not as a simple events | Charts and Charting in Excel | |||
How do I convert an existing MS Excel worksheet tracking a simple. | Excel Discussion (Misc queries) | |||
How do I convert an existing MS Excel worksheet tracking a simple. | Excel Discussion (Misc queries) | |||
Please help correct a simple error | New Users to Excel |