{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Chart","Sheet1","Customer A","Customer B","Customer C"],"not_rendered":{"charts":3,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"Chart","index":0,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Customer A"]
[null,null,null,null,null,null,"Customer B",null,null,null,null,"Customer C"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Question is"]
[]
[null,"I want","if I click rotate button then chart change to bar chart after that click button then chart change to column chart"]
[null,"If I  select color then chart color change"]

{"sheet":"Sheet1","index":1,"n_rows":38,"n_cols":6,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Customer A","Date","Vol 1","Vol 2","Vol 3"]
[null,null,"2012-01-03",1155,1147,1140]
[null,null,"2012-01-04",1675,1456,1444]
[null,null,"2012-01-05",1757,1238,1222]
[null,null,"2012-01-06",1327,1155,1147]
[null,null,"2012-01-07",1510,1286,1283]
[null,null,"2012-01-08",1336,1051,1040]
[null,null,"2012-01-09",1399,1042,1035]
[null,"Last Day","2012-01-10",1057,1010,1002]
[null,"Weekly",null,{"$f":"SUM(D4:D10)","v":10061},{"$f":"SUM(E4:E10)","v":8238},{"$f":"SUM(F4:F10)","v":8173}]
[null,"MTD",null,{"$f":"SUM(D3:D10)","v":11216},{"$f":"SUM(E3:E10)","v":9385},{"$f":"SUM(F3:F10)","v":9313}]
[]
[]
[null,"Customer B","Date","Vol 1","Vol 2","Vol 3"]
[null,null,"2012-01-03",1757,1238,1222]
[null,null,"2012-01-04",1327,1155,1147]
[null,null,"2012-01-05",1510,1286,1283]
[null,null,"2012-01-06",1336,1051,1040]
[null,null,"2012-01-07",1456,1444,1440]
[null,null,"2012-01-08",1238,1222,1220]
[null,null,"2012-01-09",1155,1147,1141]
[null,"Last Day","2012-01-10",1010,1002,1000]
[null,"Weekly",null,{"$f":"SUM(D17:D23)","v":9032},{"$f":"SUM(E17:E23)","v":8307},{"$f":"SUM(F17:F23)","v":8271}]
[null,"MTD",null,{"$f":"SUM(D16:D23)","v":10789},{"$f":"SUM(E16:E23)","v":9545},{"$f":"SUM(F16:F23)","v":9493}]
[]
[]
[null,"Customer C","Date","Vol 1","Vol 2","Vol 3"]
[null,null,"2012-01-03",1140,1238,1225]
[null,null,"2012-01-04",1444,1155,1145]
[null,null,"2012-01-05",1222,1286,1280]
[null,null,"2012-01-06",1147,1051,1046]
[null,null,"2012-01-07",1283,1444,1443]
[null,null,"2012-01-08",1040,1222,1221]
[null,null,"2012-01-09",1035,1147,1144]
[null,"Last Day","2012-01-10",1002,1002,998]
[null,"Weekly",null,null,{"$f":"SUM(E30:E36)","v":8307},{"$f":"SUM(F30:F36)","v":8277}]
[null,"MTD",null,null,{"$f":"SUM(E29:E36)","v":9545},{"$f":"SUM(F29:F36)","v":9502}]

{"sheet":"Customer A","index":2,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Date","Vol 1","Vol 2","Vol 3"]
[null,null,"2012-01-03",1155,1147,1140]
[null,null,"2012-01-04",1675,1456,1444]
[null,null,"2012-01-05",1757,1238,1222]
[null,null,"2012-01-06",1327,1155,1147]
[null,null,"2012-01-07",1510,1286,1283]
[null,null,"2012-01-08",1336,1051,1040]
[null,null,"2012-01-09",1399,1042,1035]
[null,null,"2012-01-10",1057,1010,1002]

{"sheet":"Customer B","index":3,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Date","Vol 1","Vol 2","Vol 3"]
[null,null,"2012-01-03",1757,1238,1222]
[null,null,"2012-01-04",1327,1155,1147]
[null,null,"2012-01-05",1510,1286,1283]
[null,null,"2012-01-06",1336,1051,1040]
[null,null,"2012-01-07",1456,1444,1440]
[null,null,"2012-01-08",1238,1222,1220]
[null,null,"2012-01-09",1155,1147,1141]
[null,null,"2012-01-10",1010,1002,1000]

{"sheet":"Customer C","index":4,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Date","Vol 1","Vol 2","Vol 3"]
[null,null,"2012-01-03",1140,1238,1225]
[null,null,"2012-01-04",1444,1155,1145]
[null,null,"2012-01-05",1222,1286,1280]
[null,null,"2012-01-06",1147,1051,1046]
[null,null,"2012-01-07",1283,1444,1443]
[null,null,"2012-01-08",1040,1222,1221]
[null,null,"2012-01-09",1035,1147,1144]
[null,null,"2012-01-10",1002,1002,998]