Thanks Andy
But I need a dynamic chart when data grow the SPC lines expand too.
I just need a macro to draw lines of mean and upper/lower 3 sigma control
lines
Thnks
Daniel

"Andy Pope" wrote:

Hi

No need for VBA. See here for suggestions on how to add datum lines to
charts.
http://peltiertech.com/Excel/Charts/RunChtLines.html

Cheers
Andy

Daniel wrote:
Hi
I need a simple sub VBA to draw 3 red lines of mean, upper/lower control
limits (3 sigma). How can I do that?
Thnks for your help.
Daniel