Control Limits on Chart

  • Thread starter sara_in_ga via AccessMonster.com
  • Start date
S

sara_in_ga via AccessMonster.com

Hi,

I have a database that stores various information on parts like height,
length etc. I would like to plot these as a chart with upper and lower
control limits. I have figured out how to post the data in a chart but can't
figure out how to do the control limits.

Any help would be appreciated.

Thanks,
Sara
 
R

Roger Carlson

You can't use Access charting to create control limits. However, I use a
produce called QA-ActiveSPC, which is an ActiveX SPC chart control. It's
made by a company called Quality America. You'll have to use a lot of VBA
to implement it, but it comes with samples and the tech support is
reasonably good. There may be other controls out there available too.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Chart Question 2
How can I display upper and lower control limits as a line? 1
Control Charts: "Floating Maximum" 1
Access 2007 chart on form 3
Upper Control Limits 2
Upper/lower control limits? 1
line chart with out of control limits set on it 1
How to dynamically set the lower and upper limits of the axes scaleson a MS Access xy-chart 3

Top