I need this data within a few hours if possible! I have uploaded the data. Column C & D are observed vs. forecast data. I want the binned average for data in columns C in column E and I the same thing for column D in column F. I pulled up a formula for binned averages and placed it in E1 & F1 but nothing seems to happen. I tried copying down the lengthe of the column and still nothing. Help! Thanks. binnedso4konascatter12.xls
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.