Chart Error

[Asyra]

Hi Everyone

I need a stacked chart from the data in the mock file that refreshes when I change the data in the table but i get an error message (as seen in the file) and it doesn't update the chart. Your help would be much appreciated

[Andy Pope]

You have calculation set to Manual.

Use ribbon Formulas > Calculation > Calculation Options > Automatic