inserting updatable data

[Jamie Martin]

I have a histogram chart. I also want to include, in a text box or something
like it, the mean and standard deviation of the data. But I want these two
numbers to update automatically if I change the data. Is there a way to do
this?

Thanks,

Jamie

 

[Art]

Huh? I've tried what you have suggested, but I get an
error every time I try to create the formula. I'm using
XL 2002. I've tried this with and without a textbox.
I've tried this with the chart selected, or the textbox
selected. What am I missing?

Thanks.

Art