LinkBack URL
About LinkBacks
I need to prepare a control (line) chart with mean, upper & lower control limits and each time the value is entered the chart should be automaticaly updated.
I prefer mean & control limits to be added as XY chart.
I need to prepare a control (line) chart with mean, upper & lower control limits and each time the value is entered the chart should be automaticaly updated.
I prefer mean & control limits to be added as XY chart.
Hi aka1,
This can be achieved using defined names and some stats functions like Average, STDEV.. would suggest you to upload a sample workbook. Thanks.
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com
Hi,
Thanks for reply. I've attached the sample workbook.
aka1
HI aka1,
I have used the Mean(average), standard deviation to built up UCL, LCL in attached file.. see it and let me know if this helps. thanks.
Test data.xls
Also, the defined names are used to handle increase /decrease in the data size
Regards,
DILIPandey
<click on below 'star' if this helps>
How defined names are used to handle the data size? Could you pls. explain? I've to prepare many similar charts with this feature.
Is it possible you to explain how XY scatter charts can be used to draw the CLs? I saw an example somewhere, but it not clear to me.
Regards
aka1
Hi aka1,
For defined names, press Ctrl + F3.. you will see the name manager, click on the names and you'll see the formula (logics) used there .. try understanding them as simple offset function is used there
For xy scatter charts, try changing the chart type to it.. thanks.
Regards,
DILIPandey
<click on below 'star' if this helps>
Thank you very much DILIPandey. Will understand the fomula. Your assistance is really helpful for me to draw dynamic control charts, which make my work easier.
Best Regards,
aka1
You are welcome aka1..
cheers
Suggest you to mark this thread as [SOLVED]... thanks.
Regards,
DILIPandey
<click on below 'star' if this helps>
Nice work DILIPandey !
but i want to ask you where is the code in sample file you added or how did you do that?
Hi Saiftraders,
There is no code.. just the defined names.. press Ctrl + F3 and you'll see the names and then you can see the formulas there. thanks.
Regards,
DILIPandey
<click on below 'star' if this helps>
@ aka1
Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.
Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
Dear DILIPandey,
I studied the furmula & did some home work. It was working well. But when I apply it for real data, the chart was not dynamic. I've attached the Excel sheet. Could you please look into it & let me know where is the problem.
Regards,
aka1
Cutter,
I looked for the Solved feature. But I couldn't locate it. Now I know.
Rds.
aka1
Hi aka1,
It is working fine.. I have added a new row and chart get updated automatically.. see attached:-But when I apply it for real data, the chart was not dynamic
Control Chart.xls
Regards,
DILIPandey
<click on below 'star' if this helps>
Hi,
It's working for me also. Onlything, it takes sometime. I suppose it's due to my file saved in a server. I was expecting an instant update.
Thank you.
Regards,
aka1
Ok.. I think then its fine as this is server connection issue .. thanks.
regards,
DILIPandey
<click on below 'star' if this helps>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks