I am capturing data in a table and graphing it using excel 2007. I have added vertical error bars to show 2 standard deviation units. This works well, however, as I capture more and more data, the graph becomes cluttered.

How can I create horizontal standard deviation lines that automatically update as the data is entered?

Thanks,

Chris