Brian -

I don't know how the StatPlus add-in works. It seems strange that an Excel
programmer wouldn't allow dynamic ranges for a chart like this, since you're always
adding data to a run chart, by definition.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Brian Sells wrote:

Jon,
I don't know what the formulas are that StatPlus uses. It's just a wizard
that you use to create the charts. Problem is it doesn't allow you to make
the xbar or moving range charts dynamic. I was able to get around this by
creating a dynamic range for the data rather than a dynamic chart. If you
look at the chart properties it still says it's a static chart but it
actually works dynamically.The methods described in your page for manually
creating the lines didn't work. I wasnt able to paste them in and when typed
in manually I got a formula error.
I don't really know the limits which is why I'm creating the charts. I had
another idea today that would work for what I want to do, I believe anyway
but I am not sure to go about doing it. Is there a way I could create a
button in the worksheet that would recreate the chart any time it was pushed.
Tried making a macro for this but it didn't work. I wouldn't need the chart
to be dynamic if I could create something like this that would automatically
overwrite the previous chart. I just don't want to have to go through the
whole process of creating a new chart everytime my data changes. Any thoughts
on this? I don't know any visual basic but can probably learn it pretty quick
to accomplish what I need. Thanks in advance for any more help you can offer
up.
Regards,
Brian