Forum Discussion
How do I slow the plot of a curve?
Via a video for students, I want to capture the plot of a curve that displays the rate of change. How do I slow the plot of a curve?
Please explain in detail what you mean by "slow the plot".
The plot display is almost instantaneous. For the student's benefit, it would be better if that took a few seconds ... starting at x = 0, then ending at x = max value of the plot.
- Have you considered building the chart in PowerPoint (uses Excel's charting engine) and then apply an animation to the chart? PowerPoint has options for animating by data series, element, etc.
- I decided to abandon this idea. I have higher priorities.
Thanks to HansVogelaar, PeterBartholomew1, and Patrick2788!
This can be done using VBA. See the attached workbook. You'll have to allow macros.
- Good potential!
I have used macros for many years. With Office 365, they work with other Excel spreadsheets, only when I also have Personal.xlsb also open (which also has those macros). This is unlike previous versions of Excel.
I do have the Developer tab. However. I do not recall some items.. Options > Trust Center > Trust Center Settings > Privacy Options > ???1) After downloading the workbook, right-click it in File Explorer and select Properties from the context menu.
If there is an Unblock button or link, click it.
2) In Excel, select File > Options > Trust Center > Trust Center Settings... > Trusted Locations.
Click Add new location...
Add the folder to which you downloaded the workbook, then OK your way out.
You should now be able to open the workbook and click the button.
