laitimes

How does Excel simulate a Cartesian function?

Cartesian functions:

How does Excel simulate a Cartesian function?

formula

1. Data preparation: a. Fill the data from -1.81 to +1.81 in column a, with an interval of 0.02.

b. Insert scatter plot based on data and remove excess elements of the chart to fill in the background. Refer to the following figure:

How does Excel simulate a Cartesian function?

Generate data

Second, set the data changes:

The a.c3 formula is as follows, the purpose is to randomly produce some numbers in column c:

=if(rand()>0.9,b3*rand(),na())

b.c column is the position of the small star on the heart chart. It is also possible to leave the settings blank.

3. Add background music

a. The method of inserting a music player in excel is as follows:

How does Excel simulate a Cartesian function?

b. Fill in the music playback controls with the full path of the music file downloaded in advance.

How does Excel simulate a Cartesian function?

c. After the setting is complete, you can place this player under the heart chart, and then add the following code in the vbe environment:

How does Excel simulate a Cartesian function?

The final result is as follows:

Isn't the romance of mathematics also very aesthetic?

Note: 1. During the process of setting the player properties, you need to click Development Tools - Development Mode to set the properties.

2. Any questions in the actual editing process can be left in the comment area.

Pay attention to forward thank you!!!

Read on