{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Visualize Product Sales - Data","Report","ChartData"],"not_rendered":{"charts":1,"images":2,"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":"Visualize Product Sales - Data","index":0,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,9,0,11]]}
[null,"How do you Visualize Product Sales Data"]
[null,"Visualization Challenge from Chandoo.org"]
[]
[null,null,"Sum of Quantity",null,null,null,null,"Per Unit Revenue"]
[null,"Product Name","Jan","Feb","Mar","Apr","May",{"$f":"C5","v":"Jan"},{"$f":"D5","v":"Feb"},{"$f":"E5","v":"Mar"},{"$f":"F5","v":"Apr"},{"$f":"G5","v":"May"}]
[null,"Dashboard Tutorial #1",29,35,34,57,25,37,34.885714285714286,37,35.571929824561401,45.12]
[null,"Excel Formula e-book",16,15,62,24,15,10,10,10,9.5833333333333339,10]
[null,"Excel School - Dashboards Membership",121,42,50,32,35,177.04214876033055,185.60000000000002,188.29679999999999,191.27812499999999,191.96]
[null,"Excel School - Download Membership",42,25,13,10,11,88.160714285714292,92.1,93.584615384615375,97,94.354545454545445]
[null,"Excel School - Online Membership",12,10,7,2,2,64.5,60.2,66.042857142857144,67,67]
[null,"PM Templates for Excel [2003]",15,22,16,12,18,30,30,30,30,30]
[null,"PM Templates for Excel [2007]",72,106,96,114,115,29.583333333333332,29.730849056603777,29.075104166666666,29.473684210526315,29.478260869565219]
[null,"PM Templates for Excel [both]",20,14,14,14,17,45,45,43.928571428571431,45,45]
[null,"Total",{"$f":"SUM(C6:C13)","v":327},{"$f":"SUM(D6:D13)","v":269},{"$f":"SUM(E6:E13)","v":292},{"$f":"SUM(F6:F13)","v":265},{"$f":"SUM(G6:G13)","v":238}]

{"sheet":"Report","index":1,"n_rows":26,"n_cols":3,"rows_kept":26,"cut":false,"hidden":false,"merged":[[2,5,28,5],[2,6,28,6],[2,7,28,7],[2,8,28,8],[2,9,28,9],[2,4,28,4]]}
[]
[]
[{"$f":"ChartData!G2+4","v":9}]
[{"$f":"ChartData!J2","v":12},{"$f":"ChartData!C4","v":"Product Name"},{"$f":"ChartData!H2","v":"Apr"}]
[]
[null,{"$f":"ChartData!C5","v":"Dashboard Tutorial #1"},{"$f":"OFFSET(ChartData!C5,0,ChartData!$G$2)","v":35.571929824561401}]
[]
[null,{"$f":"ChartData!C7","v":"Excel Formula e-book"},{"$f":"OFFSET(ChartData!C7,0,ChartData!$G$2)","v":9.5833333333333339}]
[]
[null,{"$f":"ChartData!C9","v":"Excel School - Dashboards Membership"},{"$f":"OFFSET(ChartData!C9,0,ChartData!$G$2)","v":191.27812499999999}]
[]
[null,{"$f":"ChartData!C11","v":"Excel School - Download Membership"},{"$f":"OFFSET(ChartData!C11,0,ChartData!$G$2)","v":97}]
[]
[null,{"$f":"ChartData!C13","v":"Excel School - Online Membership"},{"$f":"OFFSET(ChartData!C13,0,ChartData!$G$2)","v":67}]
[]
[null,{"$f":"ChartData!C15","v":"PM Templates for Excel [2003]"},{"$f":"OFFSET(ChartData!C15,0,ChartData!$G$2)","v":30}]
[]
[null,{"$f":"ChartData!C17","v":"PM Templates for Excel [2007]"},{"$f":"OFFSET(ChartData!C17,0,ChartData!$G$2)","v":29.473684210526315}]
[]
[null,{"$f":"ChartData!C19","v":"PM Templates for Excel [both]"},{"$f":"OFFSET(ChartData!C19,0,ChartData!$G$2)","v":45}]
[]
[null,{"$f":"IF(ChartData!$C$2=2, \"\", ChartData!C21)","v":""},{"$f":"IF(ChartData!$C$2=2,\"\",OFFSET(ChartData!C21,0,ChartData!$G$2))","v":""}]
[]
[]
[null,"Select a product above to highlight series"]
[null,"Click a month on the chart display breakdown above"]

{"sheet":"ChartData","index":2,"n_rows":31,"n_cols":16,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COLUMN()","v":14}]
[null,null,2,{"$f":"CHOOSE(C2,'Visualize Product Sales - Data'!C4,'Visualize Product Sales - Data'!H4, \"Total Revenue\")","v":"Per Unit Revenue"},null,null,5,{"$f":"OFFSET(C4,0,G2)","v":"Apr"},null,12,{"$f":"VLOOKUP(J2,B5:C21,2,TRUE)","v":"Excel School - Download Membership"},null,null,{"$f":"OFFSET(B4,MATCH(J2,B5:B21),-1)","v":5}]
[]
[null,null,{"$f":"'Visualize Product Sales - Data'!B5","v":"Product Name"},{"$f":"CHOOSE(C2,\"Total YTD\", \"Average YTD\",\"Total YTD\")","v":"Average YTD"},{"$f":"'Visualize Product Sales - Data'!C5","v":"Jan"},{"$f":"'Visualize Product Sales - Data'!D5","v":"Feb"},{"$f":"'Visualize Product Sales - Data'!E5","v":"Mar"},{"$f":"'Visualize Product Sales - Data'!F5","v":"Apr"},{"$f":"'Visualize Product Sales - Data'!G5","v":"May"},"Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
[8,6,{"$f":"'Visualize Product Sales - Data'!B6","v":"Dashboard Tutorial #1"},{"$f":"CHOOSE($C$2,SUM(E5:P5),AVERAGE(E5:P5),SUM(E5:P5))","v":37.915528822055137},{"$f":"CHOOSE($C$2,'Visualize Product Sales - Data'!C6,'Visualize Product Sales - Data'!H6, 'Visualize Product Sales - Data'!C6*'Visualize Product Sales - Data'!H6)","v":37},{"$f":"CHOOSE($C$2,'Visualize Product Sales - Data'!D6,'Visualize Product Sales - Data'!I6, 'Visualize Product Sales - Data'!D6*'Visualize Product Sales - Data'!I6)","v":34.885714285714286},{"$f":"CHOOSE($C$2,'Visualize Product Sales - Data'!E6,'Visualize Product Sales - Data'!J6, 'Visualize Product Sales - Data'!E6*'Visualize Product Sales - Data'!J6)","v":37},{"$f":"CHOOSE($C$2,'Visualize Product Sales - Data'!F6,'Visualize Product Sales - Data'!K6, 'Visualize Product Sales - Data'!F6*'Visualize Product Sales - Data'!K6)","v":35.571929824561401},{"$f":"CHOOSE($C$2,'Visualize Product Sales - Data'!G6,'Visualize Product Sales - Data'!L6, 'Visualize Product Sales - Data'!G6*'Visualize Product Sales - Data'!L6)","v":45.12}]
[null,null,6,null,{"$f":"IF($C6=$J$2,E5,\"\")","v":""},{"$f":"IF($C6=$J$2,F5,\"\")","v":""},"","",""]
[7,8,{"$f":"'Visualize Product Sales - Data'!B7","v":"Excel Formula e-book"},{"$f":"CHOOSE($C$2,SUM(E7:P7),AVERAGE(E7:P7),SUM(E7:P7))","v":9.9166666666666679},{"$f":"CHOOSE($C$2,'Visualize Product Sales - Data'!C7,'Visualize Product Sales - Data'!H7, 'Visualize Product Sales - Data'!C7*'Visualize Product Sales - Data'!H7)","v":10},{"$f":"CHOOSE($C$2,'Visualize Product Sales - Data'!D7,'Visualize Product Sales - Data'!I7, 'Visualize Product Sales - Data'!D7*'Visualize Product Sales - Data'!I7)","v":10},{"$f":"CHOOSE($C$2,'Visualize Product Sales - Data'!E7,'Visualize Product Sales - Data'!J7, 'Visualize Product Sales - Data'!E7*'Visualize Product Sales - Data'!J7)","v":10},{"$f":"CHOOSE($C$2,'Visualize Product Sales - Data'!F7,'Visualize Product Sales - Data'!K7, 'Visualize Product Sales - Data'!F7*'Visualize Product Sales - Data'!K7)","v":9.5833333333333339},{"$f":"CHOOSE($C$2,'Visualize Product Sales - Data'!G7,'Visualize Product Sales - Data'!L7, 'Visualize Product Sales - Data'!G7*'Visualize Product Sales - Data'!L7)","v":10}]
[null,null,8,null,{"$f":"IF($C8=$J$2,E7,\"\")","v":""},{"$f":"IF($C8=$J$2,F7,\"\")","v":""},{"$f":"IF($C8=$J$2,G7,\"\")","v":""},{"$f":"IF($C8=$J$2,H7,\"\")","v":""},{"$f":"IF($C8=$J$2,I7,\"\")","v":""}]
[6,10,{"$f":"'Visualize Product Sales - Data'!B8","v":"Excel School - Dashboards Membership"},186.83541475206613,{"$f":"CHOOSE($C$2,'Visualize Product Sales - Data'!C8,'Visualize Product Sales - Data'!H8, 'Visualize Product Sales - Data'!C8*'Visualize Product Sales - Data'!H8)","v":177.04214876033055},{"$f":"CHOOSE($C$2,'Visualize Product Sales - Data'!D8,'Visualize Product Sales - Data'!I8, 'Visualize Product Sales - Data'!D8*'Visualize Product Sales - Data'!I8)","v":185.60000000000002},{"$f":"CHOOSE($C$2,'Visualize Product Sales - Data'!E8,'Visualize Product Sales - Data'!J8, 'Visualize Product Sales - Data'!E8*'Visualize Product Sales - Data'!J8)","v":188.29679999999999},{"$f":"CHOOSE($C$2,'Visualize Product Sales - Data'!F8,'Visualize Product Sales - Data'!K8, 'Visualize Product Sales - Data'!F8*'Visualize Product Sales - Data'!K8)","v":191.27812499999999},{"$f":"CHOOSE($C$2,'Visualize Product Sales - Data'!G8,'Visualize Product Sales - Data'!L8, 'Visualize Product Sales - Data'!G8*'Visualize Product Sales - Data'!L8)","v":191.96}]
[null,null,10,null,{"$f":"IF($C10=$J$2,E9,\"\")","v":""},{"$f":"IF($C10=$J$2,F9,\"\")","v":""},{"$f":"IF($C10=$J$2,G9,\"\")","v":""},{"$f":"IF($C10=$J$2,H9,\"\")","v":""},{"$f":"IF($C10=$J$2,I9,\"\")","v":""}]
[5,12,{"$f":"'Visualize Product Sales - Data'!B9","v":"Excel School - Download Membership"},93.039975024975021,{"$f":"CHOOSE($C$2,'Visualize Product Sales - Data'!C9,'Visualize Product Sales - Data'!H9, 'Visualize Product Sales - Data'!C9*'Visualize Product Sales - Data'!H9)","v":88.160714285714292},{"$f":"CHOOSE($C$2,'Visualize Product Sales - Data'!D9,'Visualize Product Sales - Data'!I9, 'Visualize Product Sales - Data'!D9*'Visualize Product Sales - Data'!I9)","v":92.1},{"$f":"CHOOSE($C$2,'Visualize Product Sales - Data'!E9,'Visualize Product Sales - Data'!J9, 'Visualize Product Sales - Data'!E9*'Visualize Product Sales - Data'!J9)","v":93.584615384615375},{"$f":"CHOOSE($C$2,'Visualize Product Sales - Data'!F9,'Visualize Product Sales - Data'!K9, 'Visualize Product Sales - Data'!F9*'Visualize Product Sales - Data'!K9)","v":97},{"$f":"CHOOSE($C$2,'Visualize Product Sales - Data'!G9,'Visualize Product Sales - Data'!L9, 'Visualize Product Sales - Data'!G9*'Visualize Product Sales - Data'!L9)","v":94.354545454545445}]
[null,null,12,null,{"$f":"IF($C12=$J$2,E11,\"\")","v":88.160714285714292},{"$f":"IF($C12=$J$2,F11,\"\")","v":92.1},{"$f":"IF($C12=$J$2,G11,\"\")","v":93.584615384615375},{"$f":"IF($C12=$J$2,H11,\"\")","v":97},{"$f":"IF($C12=$J$2,I11,\"\")","v":94.354545454545445}]
[4,14,{"$f":"'Visualize Product Sales - Data'!B10","v":"Excel School - Online Membership"},64.948571428571427,{"$f":"CHOOSE($C$2,'Visualize Product Sales - Data'!C10,'Visualize Product Sales - Data'!H10, 'Visualize Product Sales - Data'!C10*'Visualize Product Sales - Data'!H10)","v":64.5},{"$f":"CHOOSE($C$2,'Visualize Product Sales - Data'!D10,'Visualize Product Sales - Data'!I10, 'Visualize Product Sales - Data'!D10*'Visualize Product Sales - Data'!I10)","v":60.2},{"$f":"CHOOSE($C$2,'Visualize Product Sales - Data'!E10,'Visualize Product Sales - Data'!J10, 'Visualize Product Sales - Data'!E10*'Visualize Product Sales - Data'!J10)","v":66.042857142857144},{"$f":"CHOOSE($C$2,'Visualize Product Sales - Data'!F10,'Visualize Product Sales - Data'!K10, 'Visualize Product Sales - Data'!F10*'Visualize Product Sales - Data'!K10)","v":67},{"$f":"CHOOSE($C$2,'Visualize Product Sales - Data'!G10,'Visualize Product Sales - Data'!L10, 'Visualize Product Sales - Data'!G10*'Visualize Product Sales - Data'!L10)","v":67}]
[null,null,14,null,{"$f":"IF($C14=$J$2,E13,\"\")","v":""},{"$f":"IF($C14=$J$2,F13,\"\")","v":""},{"$f":"IF($C14=$J$2,G13,\"\")","v":""},{"$f":"IF($C14=$J$2,H13,\"\")","v":""},{"$f":"IF($C14=$J$2,I13,\"\")","v":""}]
[3,16,{"$f":"'Visualize Product Sales - Data'!B11","v":"PM Templates for Excel [2003]"},30,{"$f":"CHOOSE($C$2,'Visualize Product Sales - Data'!C11,'Visualize Product Sales - Data'!H11, 'Visualize Product Sales - Data'!C11*'Visualize Product Sales - Data'!H11)","v":30},{"$f":"CHOOSE($C$2,'Visualize Product Sales - Data'!D11,'Visualize Product Sales - Data'!I11, 'Visualize Product Sales - Data'!D11*'Visualize Product Sales - Data'!I11)","v":30},{"$f":"CHOOSE($C$2,'Visualize Product Sales - Data'!E11,'Visualize Product Sales - Data'!J11, 'Visualize Product Sales - Data'!E11*'Visualize Product Sales - Data'!J11)","v":30},{"$f":"CHOOSE($C$2,'Visualize Product Sales - Data'!F11,'Visualize Product Sales - Data'!K11, 'Visualize Product Sales - Data'!F11*'Visualize Product Sales - Data'!K11)","v":30},{"$f":"CHOOSE($C$2,'Visualize Product Sales - Data'!G11,'Visualize Product Sales - Data'!L11, 'Visualize Product Sales - Data'!G11*'Visualize Product Sales - Data'!L11)","v":30}]
[null,null,16,null,{"$f":"IF($C16=$J$2,E15,\"\")","v":""},{"$f":"IF($C16=$J$2,F15,\"\")","v":""},{"$f":"IF($C16=$J$2,G15,\"\")","v":""},{"$f":"IF($C16=$J$2,H15,\"\")","v":""},{"$f":"IF($C16=$J$2,I15,\"\")","v":""}]
[2,18,{"$f":"'Visualize Product Sales - Data'!B12","v":"PM Templates for Excel [2007]"},29.468246327339063,{"$f":"CHOOSE($C$2,'Visualize Product Sales - Data'!C12,'Visualize Product Sales - Data'!H12, 'Visualize Product Sales - Data'!C12*'Visualize Product Sales - Data'!H12)","v":29.583333333333332},{"$f":"CHOOSE($C$2,'Visualize Product Sales - Data'!D12,'Visualize Product Sales - Data'!I12, 'Visualize Product Sales - Data'!D12*'Visualize Product Sales - Data'!I12)","v":29.730849056603777},{"$f":"CHOOSE($C$2,'Visualize Product Sales - Data'!E12,'Visualize Product Sales - Data'!J12, 'Visualize Product Sales - Data'!E12*'Visualize Product Sales - Data'!J12)","v":29.075104166666666},{"$f":"CHOOSE($C$2,'Visualize Product Sales - Data'!F12,'Visualize Product Sales - Data'!K12, 'Visualize Product Sales - Data'!F12*'Visualize Product Sales - Data'!K12)","v":29.473684210526315},{"$f":"CHOOSE($C$2,'Visualize Product Sales - Data'!G12,'Visualize Product Sales - Data'!L12, 'Visualize Product Sales - Data'!G12*'Visualize Product Sales - Data'!L12)","v":29.478260869565219}]
[null,null,18,null,{"$f":"IF($C18=$J$2,E17,\"\")","v":""},{"$f":"IF($C18=$J$2,F17,\"\")","v":""},{"$f":"IF($C18=$J$2,G17,\"\")","v":""},{"$f":"IF($C18=$J$2,H17,\"\")","v":""},{"$f":"IF($C18=$J$2,I17,\"\")","v":""}]
[1,20,{"$f":"'Visualize Product Sales - Data'!B13","v":"PM Templates for Excel [both]"},44.785714285714292,{"$f":"CHOOSE($C$2,'Visualize Product Sales - Data'!C13,'Visualize Product Sales - Data'!H13, 'Visualize Product Sales - Data'!C13*'Visualize Product Sales - Data'!H13)","v":45},{"$f":"CHOOSE($C$2,'Visualize Product Sales - Data'!D13,'Visualize Product Sales - Data'!I13, 'Visualize Product Sales - Data'!D13*'Visualize Product Sales - Data'!I13)","v":45},{"$f":"CHOOSE($C$2,'Visualize Product Sales - Data'!E13,'Visualize Product Sales - Data'!J13, 'Visualize Product Sales - Data'!E13*'Visualize Product Sales - Data'!J13)","v":43.928571428571431},{"$f":"CHOOSE($C$2,'Visualize Product Sales - Data'!F13,'Visualize Product Sales - Data'!K13, 'Visualize Product Sales - Data'!F13*'Visualize Product Sales - Data'!K13)","v":45},{"$f":"CHOOSE($C$2,'Visualize Product Sales - Data'!G13,'Visualize Product Sales - Data'!L13, 'Visualize Product Sales - Data'!G13*'Visualize Product Sales - Data'!L13)","v":45}]
[null,null,20,null,{"$f":"IF($C20=$J$2,E19,\"\")","v":""},{"$f":"IF($C20=$J$2,F19,\"\")","v":""},{"$f":"IF($C20=$J$2,G19,\"\")","v":""},{"$f":"IF($C20=$J$2,H19,\"\")","v":""},{"$f":"IF($C20=$J$2,I19,\"\")","v":""}]
[null,22,{"$f":"'Visualize Product Sales - Data'!B14","v":"Total"},null,{"$f":"CHOOSE($C$2,'Visualize Product Sales - Data'!C14,\"\",\"\")","v":""},{"$f":"CHOOSE($C$2,'Visualize Product Sales - Data'!D14,\"\",\"\")","v":""},{"$f":"CHOOSE($C$2,'Visualize Product Sales - Data'!E14,\"\",\"\")","v":""},{"$f":"CHOOSE($C$2,'Visualize Product Sales - Data'!F14,\"\",\"\")","v":""},{"$f":"CHOOSE($C$2,'Visualize Product Sales - Data'!G14,\"\",\"\")","v":""}]
[]
[]
[null,null,{"$f":"'Visualize Product Sales - Data'!C4","v":"Sum of Quantity"}]
[null,null,{"$f":"'Visualize Product Sales - Data'!H4","v":"Per Unit Revenue"}]
[null,null,"Total Revenue"]
[]
[]
[]
[null,null,null,{"$f":"D2","v":"Per Unit Revenue"}]
[null,null,null,"select figures"]