The Cove Business Standards Discussion Forums More Free Files Forum Discussion Thread Post Attachments Listing Cove Discussion Forums Main Page
UL - Underwriters Laboratories - Health Sciences
Go Back   The Elsmar Cove Business Systems and Standards Discussion Forums > Common Quality Assurance Processes and Tools > Quality Tools, Improvement and Analysis > Quality Assurance and Compliance Software Tools / Solutions > Excel .xls Spreadsheet Templates and Tools
Forum Username

Elsmar Cove Forum Visitor Notice(s)

Wooden Line

How to create Stoplight Control charts with excel?


Elsmar XML RSS Feed
Elsmar Cove Forum RSS Feed

Monitor the Elsmar Forum
Sponsor Links




Courtesy Quick Links


Links that Cove visitors will find useful in your quest for knowledge:

International Standards Bodies - World Wide Standards Bodies

ASQ - American Society for Quality

International Standards Organization - ISO Standards and Information

Howard's
International Quality Services


Marcelo Antunes'
SQR Consulting, and
Medical Devices Expert Forum


Bob Doering
Bob Doering's Blogs and,
Correct SPC - Precision Machining


Ajit Basrur
Claritas Consulting, LLC


NIST's Engineering Statistics Handbook

IRCA - International Register of Certified Auditors

SAE - Society of Automotive Engineers

Quality Digest

IEST - Institute of Environmental Sciences and Technology


Some Related Topic Tags (Not all threads are Tagged)
stoplight control charts, microsoft excel .xls .xlsx spreadsheet
Reply
 
Thread Tools Search this Thread Rate Thread Content Display Modes
  Post Number #1  
Old 12th March 2009, 01:18 AM
hansin

 
 
Total Posts: 24
Please Help! How to create Stoplight Control charts with excel?

I hope to use Stoplight Control charts to control processes but I am poor in excel. Please help!

Last edited by harry; 12th March 2009 at 01:47 AM.

Sponsored Links
  Post Number #2  
Old 12th March 2009, 01:45 AM
harry

 
 
Total Posts: 6,283
Re: How to create Stoplight Control charts with excel?

This is one of Steve's post related to this subject.

This one is from google search: Create Traffic Lights With Excel
Sponsored Links

  Post Number #3  
Old 12th March 2009, 02:23 AM
howste's Avatar
howste

 
 
Total Posts: 4,498
Re: How to create Stoplight Control charts with excel?

If I understand what you're asking for, conditional formatting is probably your best bet. Excel 2007 has a lot fancier capabilities, but conditional formatting still exists in previous versions.
  Post Number #4  
Old 12th March 2009, 02:28 AM
hansin

 
 
Total Posts: 24
Re: How to create Stoplight Control charts with excel?

Quote:
In Reply to Parent Post by harry View Post

This is one of Steve's post related to this subject.

This one is from google search: Create Traffic Lights With Excel
Thanks for your reply, but what I want is different from your offer, it is one for SPC control charts!

Last edited by Stijloor; 12th March 2009 at 02:34 AM.
  Post Number #5  
Old 12th March 2009, 02:40 AM
harry

 
 
Total Posts: 6,283
Re: How to create Stoplight Control charts with excel?

You want to know how to create control charts with excel?
  Post Number #6  
Old 12th March 2009, 03:10 AM
hansin

 
 
Total Posts: 24
Re: How to create Stoplight Control charts with excel?

Quote:
In Reply to Parent Post by harry View Post

You want to know how to create control charts with excel?
You want to know how to create control charts with excel? yes!
only Stoplight Control (PLS see spc 2nd ,like pre control chart)!
  Post Number #7  
Old 12th March 2009, 03:14 AM
hansin

 
 
Total Posts: 24
Re: How to create Stoplight Control charts with excel?

[IMG]C:\Documents and Settings\Administrator\桌面\090312\停止灯控制图.jpg[/IMG]
  Post Number #8  
Old 12th March 2009, 03:17 AM
Stijloor's Avatar
Stijloor

 
 
Total Posts: 15,173
Re: How to create Stoplight Control charts with excel?

Quote:
In Reply to Parent Post by hansin View Post

[IMG]C:\Documents and Settings\Administrator\桌面\090312\停止灯控制图.jpg[/IMG]
What are you trying to post?

Stijloor.
Reply

Lower Navigation Bar
Go Back   The Elsmar Cove Business Systems and Standards Discussion Forums > Common Quality Assurance Processes and Tools > Quality Tools, Improvement and Analysis > Quality Assurance and Compliance Software Tools / Solutions > Excel .xls Spreadsheet Templates and Tools

Bookmarks



Visitors Currently Viewing this Thread: 1 (0 Registered Visitors (Members) and 1 Unregistered Guest Visitors)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Forum Search
Display Modes Rate Thread Content
Rate Thread Content:

Forum Posting Settings
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Discussion Threads
Discussion Thread Title Thread Starter Forum Replies Last Post or Poll Vote
How do I create two different columns in Excel spreadsheet ? Ajit Basrur Excel .xls Spreadsheet Templates and Tools 5 19th May 2014 03:01 PM
How to create a pop-up message in Excel raghu_1968 Excel .xls Spreadsheet Templates and Tools 18 7th August 2013 09:40 AM
How to create Drop Down Box in Excel 2007 amariepsu Excel .xls Spreadsheet Templates and Tools 2 11th July 2011 08:12 PM
How Can I Create a Bell curve in Excel 2007 bbrandon Excel .xls Spreadsheet Templates and Tools 7 15th February 2009 08:00 PM
High Cpk's and Control Charts - Is it justified to stop using control charts? MSAFAI Capability, Accuracy and Stability - Processes, Machines, etc. 7 11th August 2001 01:23 PM



The time now is 02:10 AM. All times are GMT -4.
Your time zone can be changed in your UserCP --> Options.


 
 


NOTE: This forum uses "Cookies" - A Peachfarm Internet Property