| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart automation with entry data
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell Entry That Locks Selected Cells From Any Data Entry. | Excel Worksheet Functions | |||
| Chart automation | Charts and Charting in Excel | |||
| Automation of Dynamic Chart Title and legend changes | Charts and Charting in Excel | |||
| Data Automation Transfer | Excel Worksheet Functions | |||
| Chart Automation | Charts and Charting in Excel | |||
Linear Mode
