Chart automation with entry data

[Daniel]

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
(e-mail address removed)

 

[John Mansfield]

Jon Peltier provides links to a variety of resources via the link below:

http://peltiertech.com/Excel/Charts/DynamicChartLinks.html

A search on "Dynamic Charting in Excel" or similar phrases should provide
many other examples.

 

[Daniel]

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]

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

 

[Kelly O'Day]

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