|
Chart automation with entry data
Jon Peltier provides links to a variety of resources via the link below:
http://peltiertech.com/Excel/Charts/...hartLinks.html A search on "Dynamic Charting in Excel" or similar phrases should provide many other examples. -- John Mansfield http://cellmatrix.net "Daniel" wrote: How can I make my chart automation when I enter new data ? For example I have a statistic process control chart with mean line at center and upper/lower lines. I have to draw new chart every time I have new data. How can I make it automation updating the chart when I enter new data? I know some software on the shelf but just like doing with excel so other people in my group can see it Thanks in advance Daniel |
Chart automation with entry data
Thanks John M. I will try to do it and hopefully I can do what I want no
need programming such as VB. Daniel "John Mansfield" wrote: Jon Peltier provides links to a variety of resources via the link below: http://peltiertech.com/Excel/Charts/...hartLinks.html A search on "Dynamic Charting in Excel" or similar phrases should provide many other examples. -- John Mansfield http://cellmatrix.net "Daniel" wrote: How can I make my chart automation when I enter new data ? For example I have a statistic process control chart with mean line at center and upper/lower lines. I have to draw new chart every time I have new data. How can I make it automation updating the chart when I enter new data? I know some software on the shelf but just like doing with excel so other people in my group can see it Thanks in advance Daniel |
Chart automation with entry data
Daniel,
All of the basic examples should work without any programming. Basically you create named ranges via formula references and use these named ranges as the source for your chart. -- John Mansfield http://cellmatrix.net "Daniel" wrote: Thanks John M. I will try to do it and hopefully I can do what I want no need programming such as VB. Daniel "John Mansfield" wrote: Jon Peltier provides links to a variety of resources via the link below: http://peltiertech.com/Excel/Charts/...hartLinks.html A search on "Dynamic Charting in Excel" or similar phrases should provide many other examples. -- John Mansfield http://cellmatrix.net "Daniel" wrote: How can I make my chart automation when I enter new data ? For example I have a statistic process control chart with mean line at center and upper/lower lines. I have to draw new chart every time I have new data. How can I make it automation updating the chart when I enter new data? I know some software on the shelf but just like doing with excel so other people in my group can see it Thanks in advance Daniel |
Chart automation with entry data
Daniel:
I have a number of posts on dynamic charting as well as control chart examples on my site. This link will get you to my interactive - dynamic chart table of contents. http://processtrends.com/TOC_dynamic_charts.htm Let me know if you have a specific control chart question. Kelly O'Day http://processtrends.com "Daniel" wrote in message ... How can I make my chart automation when I enter new data ? For example I have a statistic process control chart with mean line at center and upper/lower lines. I have to draw new chart every time I have new data. How can I make it automation updating the chart when I enter new data? I know some software on the shelf but just like doing with excel so other people in my group can see it Thanks in advance Daniel |
| All times are GMT +1. The time now is 07:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com