How can I have a chart automatically update daily data labels. Meaning, automatically each day, drop the previous data label, an show the current day data label.
Depends Your chart ... Your data.
One possible way is to have one label per series.
You should able to to give more details ... eg a realistic sample Excel-file.