Apr 14 2018
11:12 PM
- last edited on
Jul 25 2018
09:48 AM
by
TechCommunityAP
Apr 14 2018
11:12 PM
- last edited on
Jul 25 2018
09:48 AM
by
TechCommunityAP
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