Spreadsheet: 126419d1319679993-macro-to-create-pivot-table-pivot-chart-example
Sheet: Data

Year | Month | Account | Percentage
2010 | January | 100000 | 0.07083224169935394
2010 | February | 100000 | 0.067726013655428
2010 | March | 100000 | 0.06289300719602371
2010 | April | 100000 | 0.06747929867761868
2010 | May | 100000 | 0.07378839700675287
2010 | June | 100000 | 0.1279550316525587
2010 | July | 100000 | 0.1086913013863095
2010 | August | 100000 | 0.09067006279048911
2010 | September | 100000 | 0.08563860699876585
2010 | October | 100000 | 0.07714046827611838
2010 | November | 100000 | 0.1276974571309432
2010 | December | 100000 | 0.03948811352963799
2009 | January | 100000 | 0.07596181943396252
2009 | February | 100000 | 0.07161358205309401
2009 | March | 100000 | 0.06683068014758524
2009 | April | 100000 | 0.05591818165719604
2009 | May | 100000 | 0.08414958803373003
2009 | June | 100000 | 0.1143706455657748
2009 | July | 100000 | 0.113781792122801
2009 | August | 100000 | 0.09381398602693758
2009 | September | 100000 | 0.07078043787803685
2009 | October | 100000 | 0.077683625719671
2009 | November | 100000 | 0.07706940741833343
2009 | December | 100000 | 0.09802625394287744
2008 | January | 100000 | 0.08119278863198767
2008 | February | 100000 | 0.07372732530165528
2008 | March | 100000 | 0.07382995862541532
2008 | April | 100000 | 0.07463237852342285
2008 | May | 100000 | 0.0880211684217375
2008 | June | 100000 | 0.1078559043437881
2008 | July | 100000 | 0.1067143859923883
2008 | August | 100000 | 0.09508116331767642
2008 | September | 100000 | 0.0699693782233453
2008 | October | 100000 | 0.06763239972461756
2008 | November | 100000 | 0.07467197625729884
2008 | December | 100000 | 0.08667117263666686
2007 | January | 100000 | 0.06786966711103785
2007 | February | 100000 | 0.05836028971015413
2007 | March | 100000 | 0.0765323775776312
2007 | April | 100000 | 0.06750758319791172
2007 | May | 100000 | 0.07635390443035801
2007 | June | 100000 | 0.09869225031566707
2007 | July | 100000 | 0.1103203398559906
2007 | August | 100000 | 0.1049778232763458
2007 | September | 100000 | 0.0724649399196285
2007 | October | 100000 | 0.07163844523006846
2007 | November | 100000 | 0.09553081435868103
2007 | December | 100000 | 0.09975156501652571
2006 | January | 100000 | 0.09286824529790288
2006 | February | 100000 | 0.07503004370176197
2006 | March | 100000 | 0.1002766509480767
2006 | April | 100000 | 0.07534473780781019
2006 | May | 100000 | 0.08924099208122696
2006 | June | 100000 | 0.08749228003758422
2006 | July | 100000 | 0.09592193477084786
2006 | August | 100000 | 0.1158078767681014
2006 | September | 100000 | 0.0721827977074076
2006 | October | 100000 | 0.0625734305772485
2006 | November | 100000 | 0.06386372898678605
2006 | December | 100000 | 0.06939728131524565
2010 | January | 200000 | 0
2010 | February | 200000 | 0
2010 | March | 200000 | 0
2010 | April | 200000 | 0
2010 | May | 200000 | 0
2010 | June | 200000 | 0
2010 | July | 200000 | 0
2010 | August | 200000 | 0
2010 | September | 200000 | 0
2010 | October | 200000 | 0.4807494961578964
2010 | November | 200000 | 0.1493944890091886
2010 | December | 200000 | 0.369856014832915
2009 | January | 200000 | 0
2009 | February | 200000 | 0
2009 | March | 200000 | 0
2009 | April | 200000 | 0.6040528968899498
2009 | May | 200000 | 0.3959182839473503
2009 | June | 200000 | 0
2009 | July | 200000 | 2.881916269990552e-05
2009 | August | 200000 | 0
2009 | September | 200000 | 0
2009 | October | 200000 | 0
2009 | November | 200000 | 0
2009 | December | 200000 | 0
2008 | January | 200000 | 0
2008 | February | 200000 | 4.200630110469593e-05
2008 | March | 200000 | 0.0001412141567875168
2008 | April | 200000 | 0
2008 | May | 200000 | 0
2008 | June | 200000 | 0
2008 | July | 200000 | 0.9993876631910649
2008 | August | 200000 | 0.0003134569414026657
2008 | September | 200000 | 0.0001156594096402736
2008 | October | 200000 | 0
2008 | November | 200000 | 0
2008 | December | 200000 | 0
2007 | January | 200000 | 0
2007 | February | 200000 | 0
2007 | March | 200000 | 0.0397413296770479
2007 | April | 200000 | 0
2007 | May | 200000 | 0.4142791004113321
2007 | June | 200000 | 0
2007 | July | 200000 | 0
2007 | August | 200000 | 0.1513678424948213
2007 | September | 200000 | 0
2007 | October | 200000 | 0
2007 | November | 200000 | 0
2007 | December | 200000 | 0.3946117274167988
2006 | January | 200000 | 0
2006 | February | 200000 | 0
2006 | March | 200000 | 0
2006 | April | 200000 | 0
2006 | May | 200000 | 0
2006 | June | 200000 | 0
2006 | July | 200000 | 0
2006 | August | 200000 | 0
2006 | September | 200000 | 0
2006 | October | 200000 | 0
2006 | November | 200000 | 0
2006 | December | 200000 | 1
2010 | January | 300000 | 0.00252059108695622
2010 | February | 300000 | 0.1067829217434367
2010 | March | 300000 | 0.0393654564954603
2010 | April | 300000 | 0.09170388897157937
2010 | May | 300000 | 0.01083909809578524
2010 | June | 300000 | 0.3409127266201962
2010 | July | 300000 | 0.2134795980964808
2010 | August | 300000 | 0.00810011142348017
2010 | September | 300000 | 0.01346123617465526
2010 | October | 300000 | 0.06673306634357104
2010 | November | 300000 | 0.03167570620368658
2010 | December | 300000 | 0.07442559874471226
2009 | January | 300000 | 0
2009 | February | 300000 | 0.06375625311680856
2009 | March | 300000 | 0
2009 | April | 300000 | 0.008461113048501695
2009 | May | 300000 | 0.004611996020549424
2009 | June | 300000 | 0.8832461339832232
2009 | July | 300000 | 0.01217754817602645
2009 | August | 300000 | 0.004353174058021409
2009 | September | 300000 | 0.002436247688760133
2009 | October | 300000 | 0.003419200832256027
2009 | November | 300000 | 0.009582283494086432
2009 | December | 300000 | 0.007956049581766858
2008 | January | 300000 | -0.06997630581192811
2008 | February | 300000 | 0.1211978573939571
2008 | March | 300000 | 0
2008 | April | 300000 | 0.04618678487941386
2008 | May | 300000 | 0.006405176574332818
2008 | June | 300000 | 0.260506972208485
2008 | July | 300000 | 0.1772913153750057
2008 | August | 300000 | 0.01827014552163956
2008 | September | 300000 | 0.003340622324969861
2008 | October | 300000 | 0.1382227174234705
2008 | November | 300000 | 0.1081094500684212
2008 | December | 300000 | 0.1904452640422324
2007 | January | 300000 | 0.03403925995834169
2007 | February | 300000 | 0.0715189703679392
2007 | March | 300000 | 0.4116931894661428
2007 | April | 300000 | 0.08832405109847939
2007 | May | 300000 | 0.2167509325868382
2007 | June | 300000 | 0.06990346560890481
2007 | July | 300000 | 0
2007 | August | 300000 | 0.003555387548736522
2007 | September | 300000 | 0
2007 | October | 300000 | 0.01473621297588747
2007 | November | 300000 | 0
2007 | December | 300000 | 0.08947853038873003
2006 | January | 300000 | 0.05648141235836304
2006 | February | 300000 | 0.003490120987071394
2006 | March | 300000 | 0.004620905028919499
2006 | April | 300000 | 0.001420301135672485
2006 | May | 300000 | 0.006441376388516782
2006 | June | 300000 | 0.001577754476620168
2006 | July | 300000 | 0
2006 | August | 300000 | 0.001388090464239144
2006 | September | 300000 | 0.0273695969914475
2006 | October | 300000 | 0.00663899833148722
2006 | November | 300000 | 0.8871521863277447
2006 | December | 300000 | 0.003419257509918045
2010 | January | 400000 | 0.04717573092839834
2010 | February | 400000 | 0.1057285938857203
2010 | March | 400000 | 0.00514807365199758
2010 | April | 400000 | 0.1941507152057149
2010 | May | 400000 | 0
2010 | June | 400000 | 0.09273319985946485
2010 | July | 400000 | 0.09920678369713566
2010 | August | 400000 | 0.08496232718221113
2010 | September | 400000 | 0.08910354179679596
2010 | October | 400000 | 0.06671240429971856
2010 | November | 400000 | 0.09834621125749496
2010 | December | 400000 | 0.1167324182353478
2009 | January | 400000 | 0.09901175751217156
2009 | February | 400000 | 0.09436143104902611
2009 | March | 400000 | -0.003404850592384616
2009 | April | 400000 | 0.1577061138843341
2009 | May | 400000 | 0.1111830536099005
2009 | June | 400000 | -0.007886914090208745
2009 | July | 400000 | 0.07703501959218775
2009 | August | 400000 | 0.1196467907413578
2009 | September | 400000 | 0.1111866278232161
2009 | October | 400000 | 0.08790942613530761
2009 | November | 400000 | 0.04714414857289911
2009 | December | 400000 | 0.1061073957621927
2008 | January | 400000 | 0.06737369611756855
2008 | February | 400000 | 0.06301822540385171
2008 | March | 400000 | 0.1529539954938521
2008 | April | 400000 | 0.0001664806134551757
2008 | May | 400000 | 0.09269836737285145
2008 | June | 400000 | 0.0001841913170142369
2008 | July | 400000 | 0.1078148615690539
2008 | August | 400000 | 0.09012513838190107
2008 | September | 400000 | 0.07793717713728002
2008 | October | 400000 | 0.09061231896595648
2008 | November | 400000 | 0.09870611049244747
2008 | December | 400000 | 0.1584094371347678
2007 | January | 400000 | 0
2007 | February | 400000 | 0.05280515749342638
2007 | March | 400000 | 0.09474955637404751
2007 | April | 400000 | 0
2007 | May | 400000 | 0
2007 | June | 400000 | 0
2007 | July | 400000 | 0.09511489539374599
2007 | August | 400000 | 0
2007 | September | 400000 | 0.05201483226713987
2007 | October | 400000 | 0.1564346888156554
2007 | November | 400000 | 0.5098691241307666
2007 | December | 400000 | 0.03901174552521833
2006 | January | 400000 | 0
2006 | February | 400000 | 0.1329265336181541
2006 | March | 400000 | 0.07886852349085385
2006 | April | 400000 | 0
2006 | May | 400000 | 0.04120448089581322
2006 | June | 400000 | 0
2006 | July | 400000 | 0.1412012789490296
2006 | August | 400000 | 0.3318451904472205
2006 | September | 400000 | 0.03693216904449333
2006 | October | 400000 | 0
2006 | November | 400000 | 0.2370218235544354
2006 | December | 400000 | 0