Thread: Automatically updating charts to new data

Let me give some background information on the project I am working on. I work for a construction company and we are doing work in a hospital, where we must keep airborne particles to a minimum. We collect data at 8 separate locations, 4 times a day. For each location, we take 5 readings per collection (160 data points each day - 8*4*5). We want to have a separate chart for each location 1-8. Example chart for Location 1: On the x-axis, there will be the date, and on the y-axis, there will be the average number of airborne particles taken on that particular day for location 1. We want the graph to also plot standard deviation so that we know when there is a significant peak and we must therefore investigate the cause for the peak. We want this graph to automatically update as we input more data into the excel spreadsheet. I am familiar with excel charts, but do not know how to make it continuously update itself to new data.

Thank you,

Rick