Update chart Series without formula Learn the trick to update your chart series automatically when you add new data to your source. No formula is needed.
Dynamic Dropdown List You can easily create a dynamic dropdown list when you insert your data in a Table. But also, you must write the reference of the table in the function INDIRECT.