{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Rating Summary","Item Ratings","Creating the chart"],"not_rendered":{"charts":6,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"Rating Summary","index":0,"n_rows":37,"n_cols":7,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,2,0,6]]}
[null,null,"Showing On-Demand Details in Excel Charts"]
[]
[]
[null,null,"Items",null,"Rating",null,{"$f":"\"Reviews for \"&D28","v":"Reviews for Iron Pellets"}]
[null,null,"Instant Road",{"$f":"AVERAGEIF(Table1[Item],'Rating Summary'!C5,Table1[Rating])","v":2.8333333333333335},{"$f":"REPT($D$37,INT(D5))&REPT($E$37,(INT(D5)<>D5)+0)&REPT($F$37,INT(5-D5))","v":"\u0098\u0098\u009b\u0099\u0099"}]
[null,null,"Invisible Paint",{"$f":"AVERAGEIF(Table1[Item],'Rating Summary'!C6,Table1[Rating])","v":3},"\u0098\u0098\u0098\u0099\u0099"]
[null,null,"Iron Bird Seed",{"$f":"AVERAGEIF(Table1[Item],'Rating Summary'!C7,Table1[Rating])","v":1.1666666666666667},"\u0098\u009b\u0099\u0099\u0099"]
[null,null,"Iron Pellets",{"$f":"AVERAGEIF(Table1[Item],'Rating Summary'!C8,Table1[Rating])","v":2.9090909090909092},"\u0098\u0098\u009b\u0099\u0099"]
[null,null,"Jet Motor",{"$f":"AVERAGEIF(Table1[Item],'Rating Summary'!C9,Table1[Rating])","v":3.1428571428571428},"\u0098\u0098\u0098\u009b\u0099"]
[null,null,"Jet Propelled Pogo Stick",{"$f":"AVERAGEIF(Table1[Item],'Rating Summary'!C10,Table1[Rating])","v":3.8125},"\u0098\u0098\u0098\u009b\u0099"]
[null,null,"Jet Propelled Skis",{"$f":"AVERAGEIF(Table1[Item],'Rating Summary'!C11,Table1[Rating])","v":2.3333333333333335},"\u0098\u0098\u009b\u0099\u0099"]
[null,null,"Jet Propelled Unicycle",{"$f":"AVERAGEIF(Table1[Item],'Rating Summary'!C12,Table1[Rating])","v":2.5454545454545454},"\u0098\u0098\u009b\u0099\u0099"]
[null,null,"Jim-Dandy Wagon",{"$f":"AVERAGEIF(Table1[Item],'Rating Summary'!C13,Table1[Rating])","v":2.6},"\u0098\u0098\u009b\u0099\u0099"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Calculations"]
[]
[]
[null,null,"Selected Item",{"$f":"INDEX(lstItems,valSelItem)","v":"Iron Pellets"},4]
[null,null,"Distribution of Ratings","Distribution","Total"]
[null,1,"1 star",{"$f":"COUNTIFS(Table1[Item],'Rating Summary'!$D$28,Table1[Rating],'Rating Summary'!B30)","v":2},{"$f":"SUM($D$30:$D$34)","v":11}]
[null,2,"2 star",{"$f":"COUNTIFS(Table1[Item],'Rating Summary'!$D$28,Table1[Rating],'Rating Summary'!B31)","v":2},{"$f":"E30","v":11}]
[null,3,"3 star",{"$f":"COUNTIFS(Table1[Item],'Rating Summary'!$D$28,Table1[Rating],'Rating Summary'!B32)","v":3},{"$f":"E31","v":11}]
[null,4,"4 star",{"$f":"COUNTIFS(Table1[Item],'Rating Summary'!$D$28,Table1[Rating],'Rating Summary'!B33)","v":3},{"$f":"E32","v":11}]
[null,5,"5 star",{"$f":"COUNTIFS(Table1[Item],'Rating Summary'!$D$28,Table1[Rating],'Rating Summary'!B34)","v":1},{"$f":"E33","v":11}]
[null,null,null,null,{"$f":"E34&\" Reviews\"","v":"11 Reviews"}]
[]
[null,null,null,"\u0098","\u009b","\u0099"]

{"sheet":"Item Ratings","index":1,"n_rows":102,"n_cols":4,"rows_kept":102,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Item","Reviewer ID","Rating"]
[null,"Jet Propelled Pogo Stick",367033,3]
[null,"Jet Motor",863821,3]
[null,"Invisible Paint",379860,1]
[null,"Jet Propelled Skis",180813,1]
[null,"Jet Motor",103709,4]
[null,"Instant Road",642235,1]
[null,"Jet Motor",572937,1]
[null,"Jet Propelled Pogo Stick",326907,5]
[null,"Instant Road",311814,4]
[null,"Jet Propelled Pogo Stick",564982,4]
[null,"Jim-Dandy Wagon",103869,5]
[null,"Iron Bird Seed",622721,1]
[null,"Iron Pellets",926739,2]
[null,"Invisible Paint",752215,2]
[null,"Jim-Dandy Wagon",586548,3]
[null,"Jet Propelled Unicycle",884437,1]
[null,"Jet Propelled Unicycle",413521,2]
[null,"Jet Propelled Unicycle",826735,4]
[null,"Instant Road",507621,2]
[null,"Jet Motor",161504,3]
[null,"Jim-Dandy Wagon",672701,3]
[null,"Jet Motor",786683,5]
[null,"Instant Road",729402,3]
[null,"Iron Pellets",169415,4]
[null,"Iron Pellets",317030,3]
[null,"Instant Road",291315,1]
[null,"Invisible Paint",706589,3]
[null,"Jet Propelled Unicycle",999985,2]
[null,"Jet Propelled Skis",925256,4]
[null,"Jet Motor",182321,2]
[null,"Instant Road",839977,3]
[null,"Instant Road",827407,1]
[null,"Iron Bird Seed",944988,1]
[null,"Jet Propelled Unicycle",558078,4]
[null,"Jet Propelled Pogo Stick",358991,4]
[null,"Jim-Dandy Wagon",845564,1]
[null,"Jet Propelled Pogo Stick",498991,1]
[null,"Iron Pellets",252982,1]
[null,"Invisible Paint",788157,1]
[null,"Instant Road",534731,4]
[null,"Invisible Paint",368364,2]
[null,"Invisible Paint",766175,2]
[null,"Jet Propelled Pogo Stick",757473,3]
[null,"Jet Motor",769924,5]
[null,"Iron Bird Seed",217580,1]
[null,"Jet Motor",363007,4]
[null,"Jet Motor",772180,2]
[null,"Jet Propelled Skis",418052,4]
[null,"Invisible Paint",762068,5]
[null,"Jet Propelled Pogo Stick",254900,4]
[null,"Jet Propelled Unicycle",932850,1]
[null,"Iron Pellets",647580,2]
[null,"Instant Road",608222,3]
[null,"Iron Pellets",317230,3]
[null,"Jet Propelled Unicycle",853468,5]
[null,"Iron Bird Seed",788246,1]
[null,"Iron Pellets",861386,1]
[null,"Jet Propelled Skis",966446,1]
[null,"Jet Propelled Pogo Stick",299622,3]
[null,"Jim-Dandy Wagon",958723,1]
[null,"Jet Motor",405722,5]
[null,"Jet Propelled Skis",419673,1]
[null,"Invisible Paint",328189,3]
[null,"Jet Propelled Pogo Stick",271711,4]
[null,"Invisible Paint",981665,4]
[null,"Iron Pellets",334791,5]
[null,"Jet Propelled Pogo Stick",545797,3]
[null,"Jet Propelled Skis",529482,2]
[null,"Jet Propelled Pogo Stick",710085,4]
[null,"Iron Bird Seed",732167,1]
[null,"Jet Propelled Skis",873568,1]
[null,"Jet Propelled Skis",371327,3]
[null,"Jet Propelled Pogo Stick",664058,5]
[null,"Iron Pellets",707392,4]
[null,"Iron Bird Seed",250166,2]
[null,"Invisible Paint",805970,3]
[null,"Iron Pellets",728333,3]
[null,"Instant Road",999554,2]
[null,"Jet Propelled Pogo Stick",720066,4]
[null,"Invisible Paint",651981,5]
[null,"Instant Road",620209,5]
[null,"Jet Propelled Pogo Stick",942286,5]
[null,"Jet Propelled Unicycle",451505,1]
[null,"Jet Propelled Pogo Stick",309484,5]
[null,"Iron Pellets",860403,4]
[null,"Invisible Paint",601657,5]
[null,"Jet Motor",739108,1]
[null,"Instant Road",990237,5]
[null,"Jet Motor",917890,2]
[null,"Invisible Paint",533525,2]
[null,"Jet Propelled Skis",123532,4]
[null,"Jet Motor",254947,2]
[null,"Jet Motor",410201,5]
[null,"Jet Propelled Unicycle",469976,2]
[null,"Invisible Paint",214933,1]
[null,"Jet Propelled Pogo Stick",875839,4]
[null,"Jet Propelled Unicycle",230722,1]
[null,"Jet Propelled Unicycle",893916,5]
[null,"Invisible Paint",371124,4]
[null,"Invisible Paint",422360,5]

{"sheet":"Creating the chart","index":2,"n_rows":64,"n_cols":2,"rows_kept":64,"cut":false,"hidden":false,"merged":[[0,1,0,8]]}
[null,"Steps for creating the chart"]
[]
[]
[null,"Step 1 - Create a chart from range C29:E34"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Step 2 - Reverse the order of categories and remove legend"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Step 3 - Overlap both series, adjust gap to 50%  and adjust their order"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Step 4 - Remove grid lines, axis, format chart"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Step 5 - Resize chart, add title, add labels, remove border etc."]