'Moving' Chart in Excel: Value

This article examines Value and explains the main developments, practical implications, and context readers should understand.

Value Overview

The value of the following variable X always equals the value of the variable X before it plus the value specified in cell A1. You give the initial value of variable X to 0 (cell A4), the formula for cell A5 = A4 + $ A $ 1. Next you select a range (in this case, A5: A19) and press Ctrl + D to copy the formula from cell A5 to the remaining cells. Column B contains the function value Y = SIN (X). Then go to Insert Chart to chart the value area you created.(You should use Chart Type as XY Scatter).

In order for your chart to move, you must write a function to change the value of cell A1. Then the value of the data sheet will change and make the chart change as well. Press Alt + F11 to display the Visual Basic Editor window. In the Visual Basic window, press F7 to bring up the Code window. Write a function like this:

Sub BieuDoDongDay () Range ('A1') = 0 For i = 1 to 150 Range ('A1') = Range ('A1') + 0.035 Next i Range ('A1') = 0 End Sub

Back in Excel's window, press Alt + F8 to open the Macro window, then click Run to execute the program. You can set shortcuts for newly created functions by pressing Options. That's it, you can admire your work already.

TRAN MINH TUNG (Tan Binh, Ho Chi Minh City) - According to Echip