{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Final"],"not_rendered":{"charts":3,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":32,"n_cols":20,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Sales","Expenses","Profits","No. of Customers"]
[null,{"$f":"P32","v":7096.827256497626},{"$f":"Q32","v":6969.0377626404133},127.78949385721239,424.78722942907643]
[]
[]
[]
[null,null,null,null,null,null,null,null,4]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Monthly breakup of \"&selectedValue&\" [Jan - Dec, 2019]\"","v":"Monthly breakup of No. of Customers [Jan - Dec, 2019]"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Month","Sales","Expenses","Profits","No. of Customers",{"$f":"INDEX(P18:$S$30,,$I$7)","v":"No. of Customers"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-01-01",577.11893082188851,771.46450511506782,{"$f":"P19-Q19","v":-194.34557429317931},31.278389789952548,{"$f":"INDEX(P19:$S$30,,$I$7)","v":31.278389789952548}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-02-01",174.82195090825348,671.36678454924242,{"$f":"P20-Q20","v":-496.54483364098894},37.499475568512139,{"$f":"INDEX(P20:$S$30,,$I$7)","v":37.499475568512139}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-03-01",931.19311393429837,674.49177693174931,256.70133700254905,48.532958853626965,{"$f":"INDEX(P21:$S$30,,$I$7)","v":48.532958853626965}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-04-01",551.54976421380013,1132.5439188359878,-580.99415462218769,21.716319618291077,{"$f":"INDEX(P22:$S$30,,$I$7)","v":21.716319618291077}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-05-01",155.3199951922235,15.049357487310555,140.27063770491296,33.572415916028106,{"$f":"INDEX(P23:$S$30,,$I$7)","v":33.572415916028106}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-06-01",1030.6384802209727,345.21128110024722,685.4271991207255,40.559275209932395,{"$f":"INDEX(P24:$S$30,,$I$7)","v":40.559275209932395}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-07-01",323.39189208254061,596.95046041079922,-273.55856832825862,47.435426436018787,{"$f":"INDEX(P25:$S$30,,$I$7)","v":47.435426436018787}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-08-01",228.54014943492285,528.89060687000654,-300.35045743508368,20.969724987598795,{"$f":"INDEX(P26:$S$30,,$I$7)","v":20.969724987598795}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-09-01",1009.1346884521906,890.74642850433736,118.38825994785327,24.107639231297355,{"$f":"INDEX(P27:$S$30,,$I$7)","v":24.107639231297355}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-10-01",179.10836213795318,856.66626649626119,-677.55790435830795,43.491121474536179,{"$f":"INDEX(P28:$S$30,,$I$7)","v":43.491121474536179}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-11-01",1429.5110100546365,36.430759496474963,1393.0802505581614,45.178587343661384,{"$f":"INDEX(P29:$S$30,,$I$7)","v":45.178587343661384}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-12-01",506.49891904394616,449.22561684292981,57.273302201016349,30.445894999620755,{"$f":"INDEX(P30:$S$30,,$I$7)","v":30.445894999620755}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(P19:P30)","v":7096.827256497626},{"$f":"SUM(Q19:Q30)","v":6969.0377626404133},127.78949385721239,424.78722942907643]

{"sheet":"Sheet2","index":1,"n_rows":21,"n_cols":24,"rows_kept":21,"cut":false,"hidden":true,"merged":[[1,1,3,2],[1,3,3,4],[1,5,3,6],[1,7,3,8],[4,1,4,2],[4,3,4,4],[4,5,4,6],[4,7,4,8]]}
[]
[null,"Sales",null,"Expenses",null,"Profits",null,"No. of Customers"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Monthly Breakup of\"&\" \"&X7","v":"Monthly Breakup of Expenses"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Column number"]
[null,{"$f":"T21","v":7096.827256497626},null,{"$f":"U21","v":6969.0377626404133},null,{"$f":"V21","v":127.78949385721239},null,{"$f":"W21","v":424.78722942907643}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Month","Sales","Expenses","Profits","No. of Customers",{"$f":"INDEX(T7:W7,$K$8)","v":"Expenses"}]
[null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,"2019-01-01",577.11893082188851,771.46450511506782,{"$f":"T8-U8","v":-194.34557429317931},31.278389789952548,771.46450511506782]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-02-01",174.82195090825348,671.36678454924242,{"$f":"T9-U9","v":-496.54483364098894},37.499475568512139,671.36678454924242]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-03-01",931.19311393429837,674.49177693174931,256.70133700254905,48.532958853626965,674.49177693174931]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-04-01",551.54976421380013,1132.5439188359878,-580.99415462218769,21.716319618291077,1132.5439188359878]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-05-01",155.3199951922235,15.049357487310555,140.27063770491296,33.572415916028106,15.049357487310555]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-06-01",1030.6384802209727,345.21128110024722,685.4271991207255,40.559275209932395,345.21128110024722]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-07-01",323.39189208254061,596.95046041079922,-273.55856832825862,47.435426436018787,596.95046041079922]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-08-01",228.54014943492285,528.89060687000654,-300.35045743508368,20.969724987598795,528.89060687000654]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-09-01",1009.1346884521906,890.74642850433736,118.38825994785327,24.107639231297355,890.74642850433736]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-10-01",179.10836213795318,856.66626649626119,-677.55790435830795,43.491121474536179,856.66626649626119]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-11-01",1429.5110100546365,36.430759496474963,1393.0802505581614,45.178587343661384,36.430759496474963]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-12-01",506.49891904394616,449.22561684292981,57.273302201016349,30.445894999620755,449.22561684292981]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"total",{"$f":"SUM(T8:T19)","v":7096.827256497626},{"$f":"SUM(U8:U19)","v":6969.0377626404133},127.78949385721239,424.78722942907643,6969.0377626404133]

{"sheet":"Final","index":2,"n_rows":38,"n_cols":26,"rows_kept":38,"cut":false,"hidden":false,"merged":[[1,1,2,2],[1,4,2,5],[1,7,2,8],[1,10,2,11],[4,1,4,2],[4,4,4,5],[4,7,4,8],[4,10,4,11]]}
[]
[null,"Sales",null,null,"Expenses",null,null,"Profits",null,null,"No. of Customers",null,null,null,null,null,null,null,null,null,null,{"$f":"\"Monthly Breakup of\"&\" \"&Z3","v":"Monthly Breakup of No. of Customers"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Month","Sales","Expenses","Profits","No. of Customers",{"$f":"INDEX(V3:Y3,,$F$8)","v":"No. of Customers"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-01-01",null,771.46450511506782,{"$f":"V4-W4","v":-771.46450511506782},31.278389789952548,{"$f":"INDEX(V4:Y4,,$F$8)","v":31.278389789952548}]
[null,{"$f":"V17","v":6519.7083256757387},null,null,{"$f":"W17","v":6969.0377626404133},null,null,{"$f":"X17","v":-449.32943696467623},null,null,{"$f":"Y17","v":424.78722942907643},null,null,null,null,null,null,null,null,null,"2019-02-01",174.82195090825348,671.36678454924242,{"$f":"V5-W5","v":-496.54483364098894},37.499475568512139,37.499475568512139]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-03-01",931.19311393429837,674.49177693174931,256.70133700254905,48.532958853626965,48.532958853626965]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-04-01",551.54976421380013,1132.5439188359878,-580.99415462218769,21.716319618291077,21.716319618291077]
[null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-05-01",155.3199951922235,15.049357487310555,140.27063770491296,33.572415916028106,33.572415916028106]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-06-01",1030.6384802209727,345.21128110024722,685.4271991207255,40.559275209932395,40.559275209932395]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-07-01",323.39189208254061,596.95046041079922,-273.55856832825862,47.435426436018787,47.435426436018787]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-08-01",228.54014943492285,528.89060687000654,-300.35045743508368,20.969724987598795,20.969724987598795]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-09-01",1009.1346884521906,890.74642850433736,118.38825994785327,24.107639231297355,24.107639231297355]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-10-01",179.10836213795318,856.66626649626119,-677.55790435830795,43.491121474536179,43.491121474536179]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-11-01",1429.5110100546365,36.430759496474963,1393.0802505581614,45.178587343661384,45.178587343661384]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-12-01",506.49891904394616,449.22561684292981,57.273302201016349,30.445894999620755,30.445894999620755]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"total",{"$f":"SUM(V4:V16)","v":6519.7083256757387},{"$f":"SUM(W4:W16)","v":6969.0377626404133},-449.32943696467623,424.78722942907643,424.78722942907643]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"1- create total of every column"]
[null,"2- create one new column with index function with a cell ref on the other side of sheet on a hidden area"]
[null,"3- go to the dashboard and separete it to four area for sales , expenses , profits , no. customer ( copy them from the table )"]
[null,"4- under it give empty row "]
[null,"5- under every title put the right total by using = and the cell ref"]
[null,"6- create conditional formatting after select the four factors and ,, cell that contain ,, the cell ref on the index function , with the right color and font color"]
[null,"7- select the first column and the index column from the table and create a column chart "]
[null,"8- format the column chart "]
[null,"9- create 4 buttons "]
[null,"10- create the four macros and then assign it to the buttons"]
[null,"11- create a function to copy in the title of the chart as above"]
[null,"12- Save as Macro enable is a must "]