{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","Table","NamedRange","VBA","IgnoreEmpty","Filtered","Overview"],"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":"Dataset","index":0,"n_rows":17,"n_cols":14,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Dynamic Excel Charts",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Country","Representative","Product","Sales (USD)",null,null,null,null,null,"Country","Representative","Product","Sales (USD)"]
[null,"USA","Bob","TV",1664129,null,null,null,null,null,"USA","Bob","TV",1664129]
[null,"UK","Harry","TV",2213142,null,null,null,null,null,"UK","Harry","TV",2213142]
[null,"Japan","Jimmy","Mobile",2114994,null,null,null,null,null,"Japan","Jimmy","Mobile",2114994]
[null,"Germany","Willy","AC",1884576,null,null,null,null,null,"Germany","Willy","AC",1884576]
[null,"UK","Mike","Mobile",1683006,null,null,null,null,null,"UK","Mike","Mobile",1683006]
[null,"USA","Jason","Mobile",2810983,null,null,null,null,null,"USA","Jason","Mobile",2810983]
[null,"Italy","Cindrella","AC",2880362,null,null,null,null,null,"Italy","Cindrella","AC",2880362]
[null,"Spain","Melissa","TV",2063965,null,null,null,null,null,"Spain","Melissa","TV",2063965]
[null,"UK","Mia","AC",1620182,null,null,null,null,null,"UK","Mia","AC",1620182]
[]
[]
[]
[null,"Germany","Marc","TV",2084566]

{"sheet":"Table","index":1,"n_rows":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Creating Dynamic Charts from Excel Table",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Country","Representative","Product","Sales (USD)",null,null,null,null,null,"Country","Representative","Product","Sales (USD)"]
[null,"USA","Bob","TV",1664129,null,null,null,null,null,"USA","Bob","TV",1664129]
[null,"UK","Harry","TV",2213142,null,null,null,null,null,"UK","Harry","TV",2213142]
[null,"Japan","Jimmy","Mobile",2114994,null,null,null,null,null,"Japan","Jimmy","Mobile",2114994]
[null,"Germany","Willy","AC",1884576,null,null,null,null,null,"Germany","Willy","AC",1884576]
[null,"UK","Mike","Mobile",1683006,null,null,null,null,null,"UK","Mike","Mobile",1683006]
[null,"USA","Jason","Mobile",2810983,null,null,null,null,null,"USA","Jason","Mobile",2810983]
[null,"Italy","Cindrella","AC",2880362,null,null,null,null,null,"Italy","Cindrella","AC",2880362]
[null,"Spain","Melissa","TV",2063965,null,null,null,null,null,"Spain","Melissa","TV",2063965]
[null,"UK","Mia","AC",1620182,null,null,null,null,null,"UK","Mia","AC",1620182]
[null,"Germany","Marc","TV",2084566]

{"sheet":"NamedRange","index":2,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,12]]}
[]
[null,"Using Named Range",null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Country","Representative","Sales (USD)",null,null,null,null,null,"Country","Representative","Product","Sales (USD)"]
[null,"USA","Bob",1664129,null,null,null,null,null,"USA","Bob","TV",1664129]
[null,"UK","Harry",2213142,null,null,null,null,null,"UK","Harry","TV",2213142]
[null,"Japan","Jimmy",2114994,null,null,null,null,null,"Japan","Jimmy","Mobile",2114994]
[null,"Germany","Willy",1884576,null,null,null,null,null,"Germany","Willy","AC",1884576]
[null,"UK","Mike",1683006,null,null,null,null,null,"UK","Mike","Mobile",1683006]
[null,"USA","Jason",2810983,null,null,null,null,null,"USA","Jason","Mobile",2810983]
[null,"Italy","Cindrella",2880362,null,null,null,null,null,"Italy","Cindrella","AC",2880362]
[null,"Spain","Melissa",2063965,null,null,null,null,null,"Spain","Melissa","TV",2063965]
[null,"UK","Mia",1620182,null,null,null,null,null,"UK","Mia","AC",1620182]
[null,"Germany","Marc",2084566]

{"sheet":"VBA","index":3,"n_rows":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Using VBA Macro",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Country","Representative","Product","Sales (USD)",null,null,null,null,null,"Country","Representative","Product","Sales (USD)"]
[null,"USA","Bob","TV",1664129,null,null,null,null,null,"USA","Bob","TV",1664129]
[null,"UK","Harry","TV",2213142,null,null,null,null,null,"UK","Harry","TV",2213142]
[null,"Japan","Jimmy","Mobile",2114994,null,null,null,null,null,"Japan","Jimmy","Mobile",2114994]
[null,"Germany","Willy","AC",1884576,null,null,null,null,null,"Germany","Willy","AC",1884576]
[null,"UK","Mike","Mobile",1683006,null,null,null,null,null,"UK","Mike","Mobile",1683006]
[null,"Italy","Cindrella","AC",2880362,null,null,null,null,null,"USA","Jason","Mobile",2810983]
[null,"Spain","Melissa","TV",2063965,null,null,null,null,null,"Italy","Cindrella","AC",2880362]
[null,null,null,null,null,null,null,null,null,null,"Spain","Melissa","TV",2063965]
[null,null,null,null,null,null,null,null,null,null,"UK","Mia","AC",1620182]

{"sheet":"IgnoreEmpty","index":4,"n_rows":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Creating Dynamic Charts Ignoring Empty Values",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Country","Representative","Product","Sales (USD)",null,null,null,null,null,"Country","Representative","Product","Sales (USD)"]
[null,"USA","Bob","TV",1664129,null,null,null,null,null,"USA","Bob","TV",1664129]
[null,"UK","Harry","TV",2213142,null,null,null,null,null,"UK","Harry","TV",2213142]
[null,"Japan","Jimmy","Mobile",2114994,null,null,null,null,null,"Japan","Jimmy","Mobile",2114994]
[null,"UK","Mike","Mobile",1683006,null,null,null,null,null,"Germany","Willy","AC",1884576]
[null,"Italy","Cindrella","AC",2880362,null,null,null,null,null,"UK","Mike","Mobile",1683006]
[null,"Spain","Melissa","TV",2063965,null,null,null,null,null,"USA","Jason","Mobile",2810983]
[null,"Germany","Marc","TV",2084566,null,null,null,null,null,"Italy","Cindrella","AC",2880362]
[null,"Germany","Willy","AC",null,null,null,null,null,null,"Spain","Melissa","TV",2063965]
[null,"USA","Jason","Mobile",null,null,null,null,null,null,"UK","Mia","AC",1620182]
[null,"UK","Mia","AC"]

{"sheet":"Filtered","index":5,"n_rows":26,"n_cols":16,"rows_kept":26,"cut":false,"hidden":false,"merged":[[1,12,1,15],[15,1,15,2],[1,1,1,6],[25,13,25,18]]}
[]
[null,"Creating Filtered Dynamic Charts",null,null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Country","Representative","Product","Sales (USD)",null,"Unique List",null,null,null,null,null,"Country","Representative","Product","Sales (USD)"]
[null,"USA","Bob","TV",1664129,null,{"$f":"_xlfn.UNIQUE(D5:D14)","v":"TV"},null,null,null,null,null,"USA","Bob","TV",1664129]
[null,"UK","Harry","TV",2213142,null,"Mobile",null,null,null,null,null,"UK","Harry","TV",2213142]
[null,"Japan","Jimmy","Mobile",2114994,null,"AC",null,null,null,null,null,"Japan","Jimmy","Mobile",2114994]
[null,"Germany","Willy","AC",1884576,null,null,null,null,null,null,null,"Germany","Willy","AC",1884576]
[null,"UK","Mike","Mobile",1683006,null,null,null,null,null,null,null,"UK","Mike","Mobile",1683006]
[null,"USA","Jason","Mobile",2810983,null,null,null,null,null,null,null,"USA","Jason","Mobile",2810983]
[null,"Italy","Cindrella","AC",2880362,null,null,null,null,null,null,null,"Italy","Cindrella","AC",2880362]
[null,"Spain","Melissa","TV",2063965,null,null,null,null,null,null,null,"Spain","Melissa","TV",2063965]
[null,"UK","Mia","AC",1620182,null,null,null,null,null,null,null,"UK","Mia","AC",1620182]
[null,"Germany","Marc","TV",2084566]
[]
[null,"Product",null,"TV"]
[]
[null,"Country","Representative","Product","Sales (USD)"]
[null,{"$f":"_xlfn._xlws.FILTER(B5:E14,D5:D14=D16)","v":"USA"},"Bob","TV",1664129]
[null,"UK","Harry","TV",2213142]
[null,"Spain","Melissa","TV",2063965]
[null,"Germany","Marc","TV",2084566]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Overview Image of Dynamic Charts in Excel"]

{"sheet":"Overview","index":6,"n_rows":22,"n_cols":16,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,12,1,15],[15,1,15,2],[1,1,1,6]]}
[]
[null,"Overview Image of Dynamic Excel Charts",null,null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Country","Representative","Product","Sales (USD)",null,"Unique List",null,null,null,null,null,"Country","Representative","Product","Sales (USD)"]
[null,"USA","Bob","TV",1664129,null,{"$f":"_xlfn.UNIQUE(D5:D14)","v":"TV"},null,null,null,null,null,"USA","Bob","TV",1664129]
[null,"UK","Harry","TV",2213142,null,"Mobile",null,null,null,null,null,"UK","Harry","TV",2213142]
[null,"Japan","Jimmy","Mobile",2114994,null,"AC",null,null,null,null,null,"Japan","Jimmy","Mobile",2114994]
[null,"Germany","Willy","AC",1884576,null,null,null,null,null,null,null,"Germany","Willy","AC",1884576]
[null,"UK","Mike","Mobile",1683006,null,null,null,null,null,null,null,"UK","Mike","Mobile",1683006]
[null,"USA","Jason","Mobile",2810983,null,null,null,null,null,null,null,"USA","Jason","Mobile",2810983]
[null,"Italy","Cindrella","AC",2880362,null,null,null,null,null,null,null,"Italy","Cindrella","AC",2880362]
[null,"Spain","Melissa","TV",2063965,null,null,null,null,null,null,null,"Spain","Melissa","TV",2063965]
[null,"UK","Mia","AC",1620182,null,null,null,null,null,null,null,"UK","Mia","AC",1620182]
[null,"Germany","Marc","TV",2084566]
[]
[null,"Product",null,"TV"]
[]
[null,"Country","Representative","Product","Sales (USD)"]
[null,{"$f":"_xlfn._xlws.FILTER(B5:E14,D5:D14=D16)","v":"USA"},"Bob","TV",1664129]
[null,"UK","Harry","TV",2213142]
[null,"Spain","Melissa","TV",2063965]
[null,"Germany","Marc","TV",2084566]