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.
Excel Table
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.
