Yes it does. Even if I save the excel using Ctrl+S; it reflects the updated data in the chart. But earlier I didn't have to save or press F9 to update the data. Can you pls tell me if some latest excel update might have introduced this?

I suspected so and uninstalled the last update from my system but still the issue exists.