ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I set up a stoplight chart in excel to show % training com (https://www.excelbanter.com/excel-discussion-misc-queries/205307-how-do-i-set-up-stoplight-chart-excel-show-%25-training-com.html)

paul mauro

How do I set up a stoplight chart in excel to show % training com
 
I need a stop light chart in excell that will change from red (0-69 percent)
to yellow
(69.1% to 79.9%) to green 80% to 100 %.
Can anyone help?

Thanks

Paul

Pete_UK

How do I set up a stoplight chart in excel to show % training com
 
Check out this link to Bob Phillips' site:

http://www.xldynamic.com/source/xld.CF.html#lights

Hope this helps.

Pete

On Oct 6, 11:56*pm, paul mauro <paul
wrote:
I need a stop light chart in excell that will change from red (0-69 percent)
to yellow
(69.1% to 79.9%) to green 80% to 100 %.
Can anyone help?

Thanks

Paul




All times are GMT +1. The time now is 12:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com