Spreadsheet: 57468d1257635743-excel-2007-excel-2007-chart-horizontal-axis-dates-vanessa-tucker-work-sample2
Sheet: get pivot data

 |  |  |  | april chip 1 France revenue | total revenue
 | Values
Row Labels | Sum of Var | Sum of Budget | Sum of Revenue | Sum of Revenue2 | Sum of Var percentage of Budget
January | -4297 | 91831 | 87534 | 0.0852926789817184 | -0.04679247748581634
Chip 1 | -4297 | 91831 | 87534 | 0.0852926789817184 | -0.04679247748581634
Canada | 2929 | 29330 | 32259 | 0.03143300353315574 | 0.0998636208660075
France | -5772 | 33171 | 27399 | 0.02669744455206094 | -0.1740074161164873
US | -1454 | 29330 | 27876 | 0.02716223089650173 | -0.04957381520627344
February | 2843 | 87534 | 90377 | 0.08806288354617364 | 0.03247880823451459
Chip 2 | 2843 | 87534 | 90377 | 0.08806288354617364 | 0.03247880823451459
Canada | 3318 | 32045 | 35363 | 0.0344575251540031 | 0.1035418942112654
France | -3846 | 32954 | 29108 | 0.02836268535426074 | -0.1167081386174668
US | 3371 | 22535 | 25906 | 0.02524267303790981 | 0.1495895274018194
March | -1389 | 90377 | 88988 | 0.08670944909663854 | -0.01536895449063368
Chip 3 | -1389 | 90377 | 88988 | 0.08670944909663854 | -0.01536895449063368
Canada | -10733 | 35363 | 24630 | 0.0239993452066594 | -0.3035093176483896
France | 11529 | 20784 | 32313 | 0.0314856208551679 | 0.5547055427251733
US | -2185 | 34230 | 32045 | 0.03122448303481123 | -0.06383289512123869
April | -2774 | 87756 | 84982 | 0.0828060233192176 | -0.03161037421942659
Chip 1 | -2774 | 87756 | 84982 | 0.0828060233192176 | -0.03161037421942659
Canada | 1054 | 19289 | 20343 | 0.0198221144758048 | 0.05464254238166831
France | -54 | 37654 | 37600 | 0.03663724643809962 | -0.001434110585860732
US | -3774 | 30813 | 27039 | 0.02634666240531318 | -0.1224807711031058
May | -423 | 84982 | 84559 | 0.08239385429678898 | -0.004977524652279307
Chip 2 | -423 | 84982 | 84559 | 0.08239385429678898 | -0.004977524652279307
Canada | 8332 | 20343 | 28675 | 0.02794077238331134 | 0.4095757754510151
France | 3318 | 32045 | 35363 | 0.0344575251540031 | 0.1035418942112654
US | -12073 | 32594 | 20521 | 0.01999555675947453 | -0.3704055961219856
June | -548 | 84559 | 84011 | 0.08185988591785072 | -0.006480682127272082
Chip 3 | -548 | 84559 | 84011 | 0.08185988591785072 | -0.006480682127272082
Canada | -2823 | 30867 | 28044 | 0.02732592923165068 | -0.09145689571386918
France | -3740 | 36595 | 32855 | 0.03201374286499369 | -0.1021997540647629
US | 6015 | 17097 | 23112 | 0.02252021382120634 | 0.3518161080891384
July | 2366 | 84011 | 86377 | 0.08416530413786517 | 0.02816297865755675
Chip 1 | 2366 | 84011 | 86377 | 0.08416530413786517 | 0.02816297865755675
Canada | -5114 | 28044 | 22930 | 0.02234287395812831 | -0.182356297247183
France | -275 | 27514 | 27239 | 0.0265415413757286 | -0.009994911681325871
US | 7755 | 28453 | 36208 | 0.03528088880400827 | 0.2725547393947914
August | -2843 | 86377 | 83534 | 0.08139509957340993 | -0.03291385438253239
Chip 2 | -2843 | 86377 | 83534 | 0.08139509957340993 | -0.03291385438253239
Canada | -3855 | 27830 | 23975 | 0.02336111657854889 | -0.1385195831836148
France | 2769 | 30663 | 33432 | 0.03257596869464219 | 0.09030427551120243
US | -1757 | 27884 | 26127 | 0.02545801430021885 | -0.0630110457610099
September | 1389 | 83534 | 84923 | 0.08274853402294505 | 0.01662795987262672
Chip 3 | 1389 | 83534 | 84923 | 0.08274853402294505 | 0.01662795987262672
Canada | -1654 | 23975 | 22321 | 0.02174946749321334 | -0.06898852971845673
France | -2983 | 32200 | 29217 | 0.02846889439313714 | -0.09263975155279502
US | 6026 | 27359 | 33385 | 0.03253017213659457 | 0.2202565883255967
October | -4318 | 84923 | 80605 | 0.07854109705167606 | -0.05084606054896789
Chip 1 | -4318 | 84923 | 80605 | 0.07854109705167606 | -0.05084606054896789
Canada | 1454 | 27876 | 29330 | 0.02857900101142186 | 0.0521595637824652
France | -1917 | 29217 | 27300 | 0.02660097946170531 | -0.06561248588150734
US | -3855 | 27830 | 23975 | 0.02336111657854889 | -0.1385195831836148
November | 3406 | 80605 | 84011 | 0.08185988591785072 | 0.04225544321071894
Chip 2 | 3406 | 80605 | 84011 | 0.08185988591785072 | 0.04225544321071894
Canada | 2929 | 29330 | 32259 | 0.03143300353315574 | 0.0998636208660075
France | 0 | 23876 | 23876 | 0.02326465148819326 | 0
US | 477 | 27399 | 27876 | 0.02716223089650173 | 0.01740939450344903
December | 2366 | 84011 | 86377 | 0.08416530413786517 | 0.02816297865755675
Chip 3 | 2366 | 84011 | 86377 | 0.08416530413786517 | 0.02816297865755675
Canada | 1454 | 27876 | 29330 | 0.02857900101142186 | 0.0521595637824652
France | 912 | 32259 | 33171 | 0.03232165163825006 | 0.02827118013577606
US | 0 | 23876 | 23876 | 0.02326465148819326 | 0
Grand Total | -4222 | 1030500 | 1026278 | 1 | -0.004097040271712761