{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Welcome","Info","Interactive chart","Company A","Company B","Company C"],"not_rendered":{"charts":1,"images":3,"macros":1,"external_links":0,"defined_names":36,"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":"Welcome","index":0,"n_rows":7,"n_cols":1,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,13],[15,6,15,9],[11,6,13,9],[3,2,3,3],[1,0,1,13],[4,0,5,13],[6,0,6,13],[8,6,9,9]]}
[]
["Interacting with Charts"]
[]
[]
["This document is for training purposes only. Financial Edge accepts no responsibility or liability for any other purpose or usage."]
[]
[{"$f":"\"© \"&YEAR(TODAY())&\" Financial Edge Training\"","v":"© 2024 Financial Edge Training"}]

{"sheet":"Info","index":1,"n_rows":17,"n_cols":16,"rows_kept":17,"cut":false,"hidden":false,"merged":[[3,11,3,15],[3,1,3,8],[12,1,12,11],[17,1,17,2],[17,3,17,11],[4,13,4,16],[5,13,5,16],[6,13,6,16],[7,13,7,16],[8,13,8,16],[9,13,9,16],[12,14,12,16],[13,3,13,11],[14,3,14,11],[13,1,13,2],[14,1,14,2]]}
[{"$f":"Welcome!A2","v":"Interacting with Charts"}]
["Workout Information"]
[]
[null,"Features",null,null,null,null,null,null,null,null,null,"Model Details"]
[null,"◦","Chart object",null,null,null,null,null,null,null,null,"Company name",null,"ABC Incorporated"]
[null,"◦","Chart properties and methods",null,null,null,null,null,null,null,null,"Date",null,"2015-12-31"]
[null,"◦","Chart events",null,null,null,null,null,null,null,null,"Currency",null,"USD"]
[null,"◦","Animated charts",null,null,null,null,null,null,null,null,"Units",null,"Millions"]
[null,null,null,null,null,null,null,null,null,null,null,"Analyst Name",null,"Firstname Lastname"]
[null,null,null,null,null,null,null,null,null,null,null,"Circular Switch",null,0]
[]
[]
[null,"Tab Structure",null,null,null,null,null,null,null,null,null,null,null,null,"Formatting"]
[null,"Workouts"]
[null,"Interactive chart",null,null,null,null,null,null,null,null,null,null,null,null,null,"Input"]
[null,"Scenario Learning - Profit tree",null,null,null,null,null,null,null,null,null,null,null,null,null,"Hard coded"]
[null,"Scenario Learning - Animated chart",null,null,null,null,null,null,null,null,null,null,null,null,null,"Formulas"]

{"sheet":"Interactive chart","index":2,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Info!A1","v":"Interacting with Charts"}]
[{"$f":"Info!B15","v":"Interactive chart"}]
[]
[null,"Write VBA code to enable chart events with the chart below so that when a data series point is mouse clicked"]
[null,"the breakdown of that company's net income is displayed."]
[]
[null,"Company","Net income"]
[null,"Company A",98,null,null,null,null,null,null,null,"See InteractiveChart module"]
[null,"Company B",70]
[null,"Company C",75]

{"sheet":"Company A","index":3,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Info!A1","v":"Interacting with Charts"}]
["Company A"]
[]
[]
[null,"Revenue",1000]
[null,"COGS",-600]
[null,"Gross Profit",{"$f":"SUM(C5:C6)","v":400}]
[null,"SG&A",-180]
[null,"Operating profit",{"$f":"C7+C8","v":220}]
[null,"Interest",-90]
[null,"PBT",{"$f":"C9+C10","v":130}]
[null,"Tax",-32]
[null,"Net income",{"$f":"C11+C12","v":98}]

{"sheet":"Company B","index":4,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Info!A1","v":"Interacting with Charts"}]
["Company B"]
[]
[]
[null,"Revenue",800]
[null,"COGS",-550]
[null,"Gross Profit",{"$f":"SUM(C5:C6)","v":250}]
[null,"SG&A",-126]
[null,"Operating profit",{"$f":"C7+C8","v":124}]
[null,"Interest",-25]
[null,"PBT",{"$f":"C9+C10","v":99}]
[null,"Tax",-29]
[null,"Net income",{"$f":"C11+C12","v":70}]

{"sheet":"Company C","index":5,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Info!A1","v":"Interacting with Charts"}]
["Company C"]
[]
[]
[null,"Revenue",850]
[null,"COGS",-625]
[null,"Gross Profit",{"$f":"SUM(C5:C6)","v":225}]
[null,"SG&A",-98]
[null,"Operating profit",{"$f":"C7+C8","v":127}]
[null,"Interest",-30]
[null,"PBT",{"$f":"C9+C10","v":97}]
[null,"Tax",-22]
[null,"Net income",{"$f":"C11+C12","v":75}]