Hi,

Apologies if I have posted this in the wrong section as it could cover a few sections but I hope someone can help me or point me in the right direction.

I have a table that is imported from SQL to Excel 2013. The data on the table is set to refresh every 10 minutes. What I would like to do is create a Statistical Process Control chart that will live update as the table refreshes.
The problem is I have to calculate the Mean and Standard Deviation for to create the chart. When calculating the mean, FORMULA: =average($E$2:$E$1048576) Excel just returns a #DIV/0! error.
I have tried using a shorter range but still returns the same error. Also I tried plotting the raw data onto a chart which results in 0 values plotted on the chart.

Any help will be appreciated.
Thanks in advance,
Steve.