Cumulative Deviation
Maybe you have a day by hour chart, or sales plan vs. actual sales data and you want an easy way to decide when to take action - consider the simple Cumulative Deviation. First you need some data, two variables that you want to compare. Here in this spreadsheet example we have Plan and Actual for eight time periods.