Animated Graphs in Excel

Renaming the Command Button

If you would like, you can rename the command button.  Make sure that you are in “Design mode” by checking to see that the menu item “Design Mode” is green.  This mode can be toggled by clicking on the menu item.  If you notice that nothing seems to happen when you press one of the command buttons, there is a good chance that you are still in design mode.

Renaming the Command Button

Renaming the Command Button

Click edit and you can rename the button.  It is appropriate to name it “Run” in this instance.

Running the Command

Now you are ready to run the command.  This is as simple as pressing the Command Button you just created.  Once you press it, a point will appear on the graph.  It will then move up and to the right, just like a projectile.  If you haven’t yet set the maximum and minimum on the axes, the graph will rescale during the motion.  Note the extremes, and then format the axis to include those values.  You can also format your graph, including the proper axis labels, etc.

Next we set things up to show the time on the graph.