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.