Hello All,
I am new to this thread and i am loving the information i get in here.
I have 100 rows of data for 100 cities (10 columns).
I will be adding 100 rows to this table everyday . I need a chart to update itself for each day every time i add in the 100 rows to the existing table.
i have set up data validation for the drop down menu to select the city in another sheet
Once i select the city from the drop down menu, the chart needs to be updated each day
Please help me out on this