{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Introduction","Sheet2","Features Of This Template"],"not_rendered":{"charts":1,"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":"Introduction","index":0,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[[2,1,18,9]]}
[null,null,null,null,null,"www.Tricks12345.com"]
[]
[null,"Create Dynamic Chart\nBased on DropDown"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Pavan Kumar Gundlapalli"]

{"sheet":"Sheet2","index":1,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[[17,4,17,7],[8,12,8,16],[9,13,9,16],[10,13,10,16],[11,13,11,16],[12,13,12,16],[13,13,13,16],[12,3,12,7],[13,4,13,7],[14,4,14,7],[15,4,15,7],[16,4,16,7]]}
["Year","Sales"]
[2010,150,null,"Start",2010,null,null,"End",2020]
[2011,130]
[2012,140]
[2013,221]
[2014,584]
[2015,256]
[2016,847]
[2017,112,null,null,null,null,null,null,null,null,null,null,"Years Formula"]
[2018,257,null,null,null,null,null,null,null,null,null,null,"Reference","Sheet2!$A$2"]
[2019,368,null,null,null,null,null,null,null,null,null,null,"Rows","MATCH(Sheet2!$E$2,Sheet2!$A$2:$A$100,0)-1"]
[2020,48,null,null,null,null,null,null,null,null,null,null,"Cols",0]
[null,null,null,"Sales Formula",null,null,null,null,null,null,null,null,"Height","MATCH(Sheet2!$I$2,Sheet2!$A$2:$A$100,0)- MATCH(Sheet2!$E$2,Sheet2!$A$2:$A$100,0)+1"]
[null,null,null,"Reference","Sheet2!Year_Data",null,null,null,null,null,null,null,"Width",1]
[null,null,null,"Rows",0]
[null,null,null,"Cols",1]
[null,null,null,"Height"]
[null,null,null,"Width"]

{"sheet":"Features Of This Template","index":2,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,"(i) This is a dynamic chart"]
[null,null,null,"(ii)Provides Dynamic values in data validation dropdown"]
[null,null,null,"(iii)It allows to manipulate the content in data validation"]
[null,null,null,"(iv) Create names dynamically"]
[null,null,null,"(v)Automatically refreshes the chart based on data user has selected in drop down"]