Dynamic Range Statistical Function

[Jmwend]

I currently have a an excel worksheet that has data values continuously populating various columns. I currently have a line graph plotting the data by date. However, i would like to implement a statistical distribution curve (i.e. normal bell curve) for the data inputted, that updates as new data is entered. I would also like to implement functions that compute the mean, std, and cpk values for the continuously populating data. It would be great if somebody could help me figure this out.

Thank you in advance

 

[P_Guru]

Suggest using the whole row/column as the source range for your graphs so that they auto-update as new data is added.

Then suggest a macro that un-hides the next row/column as the one above it is filled in, before hiding all but 1 row/column (so that there is a gap for new data) to give a sensible appearing graph.