Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Jared_Hmr
 
Posts: n/a
Default 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   Report Post  
tjtjjtjt
 
Posts: n/a
Default

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   Report Post  
Ken Wright
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
New Excel user needs help with simple Macro... Rahim Kassam New Users to Excel 1 January 24th 05 03:10 PM
Ploting dates against a calendar and not as a simple events Barb Reinhardt Charts and Charting in Excel 2 January 22nd 05 03:41 AM
How do I convert an existing MS Excel worksheet tracking a simple. NOTANYJOE Excel Discussion (Misc queries) 1 January 4th 05 03:07 AM
How do I convert an existing MS Excel worksheet tracking a simple. [email protected] Excel Discussion (Misc queries) 0 January 4th 05 01:53 AM
Please help correct a simple error lwhite New Users to Excel 1 December 9th 04 10:39 PM


All times are GMT +1. The time now is 11:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"