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