recalculation and chart updates in Excel

Hi anyone,

I am using the MAC 2016 version of Excel. In older versions of Excel it was possible to set recalculation so that values in a table could change as a result of holding Command-=. Then a chart based on the table would redraw after each separate recalculation. For example if we are simulating tossing a coin we can see the number of heads and tails changing as the number of 'tosses' increases. 

See also the example of the rotating line attached.

The version of Excel I now have does not seem to do this. Neither do the recent versions of Excel for PC using F9 for recalculations. 

If it can be done, I would be very grateful to know how.

Ian