Spreadsheet: 126741d1319848812-excel-2007-total-of-data-chart-question
Sheet: Sheet2

project | fiscal year | date | category | Projected | Actual
xxxxx | 2012 | 2011-05-01 00:00:00 | Travel | 8500 | 7244.47
xxxxx | 2012 | 2011-05-01 00:00:00 | PM Hours | 14535 | 2040 |  |  |  |  | Column Labels
xxxxx | 2012 | 2011-06-01 00:00:00 | Travel | 8500 | 11940.04 |  |  |  |  | 2012 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012 Sum of Projected | 2012 Sum of Actual | Total Sum of Projected | Total Sum of Actual
xxxxx | 2012 | 2011-06-01 00:00:00 | PM Hours | 14960 | 14535 |  |  |  |  | 2011-05-01 00:00:00 |  | 2011-06-01 00:00:00 |  | 2011-07-01 00:00:00 |  | 2011-08-01 00:00:00 |  | 2011-09-01 00:00:00 |  | 2011-10-01 00:00:00 |  | 2011-11-01 00:00:00
xxxxx | 2012 | 2011-07-01 00:00:00 | Milestone Payments | 50000 | 0 |  |  |  | Row Labels | Sum of Projected | Sum of Actual | Sum of Projected | Sum of Actual | Sum of Projected | Sum of Actual | Sum of Projected | Sum of Actual | Sum of Projected | Sum of Actual | Sum of Projected | Sum of Actual | Sum of Projected | Sum of Actual
xxxxx | 2012 | 2011-07-01 00:00:00 | Hosting | 59140 | 0 |  |  |  | xxxxx | 23035 | 9284.470000000001 | 23460 | 26475.04 | 132005 | 27059.59 | 74552 | 129413.72 | 308470 | 67667 | 75232 | 304378.86 | 330997 | 0 | 967751 | 564278.6799999999 | 967751 | 564278.6799999999
xxxxx | 2012 | 2011-07-01 00:00:00 | Travel | 8500 | 12099.59 |  |  |  | Hosting |  |  |  |  | 59140 | 0 | 51772 | 59140 | 51772 | 51772 | 51772 | 51772 | 74859 | 0 | 289315 | 162684 | 289315 | 162684
xxxxx | 2012 | 2011-07-01 00:00:00 | PM Hours | 14365 | 14960 |  |  |  | Travel | 8500 | 7244.47 | 8500 | 11940.04 | 8500 | 12099.59 | 8500 | 6333.72 | 9680 | 0 | 8500 | 5928.86 | 9630 | 0 | 61810 | 43546.68 | 61810 | 43546.68
xxxxx | 2012 | 2011-08-01 00:00:00 | Milestone Payments | 0 | 50000 |  |  |  | Milestone Payments |  |  |  |  | 50000 | 0 | 0 | 50000 | 232313 | 0 |  | 232313 | 232313 | 0 | 514626 | 282313 | 514626 | 282313
xxxxx | 2012 | 2011-08-01 00:00:00 | Hosting | 51772 | 59140 |  |  |  | PM Hours | 14535 | 2040 | 14960 | 14535 | 14365 | 14960 | 14280 | 13940 | 14705 | 15895 | 14960 | 14365 | 14195 | 0 | 102000 | 75735 | 102000 | 75735
xxxxx | 2012 | 2011-08-01 00:00:00 | Travel | 8500 | 6333.72 |  |  |  | Grand Total | 23035 | 9284.470000000001 | 23460 | 26475.04 | 132005 | 27059.59 | 74552 | 129413.72 | 308470 | 67667 | 75232 | 304378.86 | 330997 | 0 | 967751 | 564278.6799999999 | 967751 | 564278.6799999999
xxxxx | 2012 | 2011-08-01 00:00:00 | PM Hours | 14280 | 13940
xxxxx | 2012 | 2011-09-01 00:00:00 | Milestone Payments | 232313 | 0
xxxxx | 2012 | 2011-09-01 00:00:00 | Hosting | 51772 | 51772
xxxxx | 2012 | 2011-09-01 00:00:00 | Travel | 9680 | 0
xxxxx | 2012 | 2011-09-01 00:00:00 | PM Hours | 14705 | 15895
xxxxx | 2012 | 2011-10-01 00:00:00 | Milestone Payments |  | 232313
xxxxx | 2012 | 2011-10-01 00:00:00 | Hosting | 51772 | 51772
xxxxx | 2012 | 2011-10-01 00:00:00 | Travel | 8500 | 5928.86
xxxxx | 2012 | 2011-10-01 00:00:00 | PM Hours | 14960 | 14365
xxxxx | 2012 | 2011-11-01 00:00:00 | Milestone Payments | 232313 | 0
xxxxx | 2012 | 2011-11-01 00:00:00 | Hosting | 74859 | 0
xxxxx | 2012 | 2011-11-01 00:00:00 | Travel | 9630 | 0
xxxxx | 2012 | 2011-11-01 00:00:00 | PM Hours | 14195 | 0