Thread: VBA to manipulate a dynamic chart

Could anyone tell me how to do write a code using excel VBA to do the following?

Attached is a dashboard and dynamic chart for 6 indicators. Each indicator has a target and new target. I do a chart for weekly data up to date and another chart for the whole year. There is a list box of the indicators. The data will be automatically updated when you click on the indicators list box.

For the indicators BXX, CXX, DXX, EXX, and FXX, the Targets are as shown in the input of executive dashboard. With respect to the fiscal year chart, the beginning value of the target is from the target column of the dashboard, the ending value of the target is from the new target column of the dashboard

To do the fiscal chart (the second one), I want the target for AXX change to the value 34.2, the beginning of the fiscal year July/02.

Could I write some code using VBA in excel so that the target for AXX will be the value on July/02, for other indicators, I want to remain the original

I want to make my question simpler:

Could anyone tell me how to write a code in VBA to made the cell T3=T2 for the indicator AXX, and remail the same T3=B3 for the other indicators BXX,CXX,.....

Thanks!

It is ok with the code belowIt doesn't work, I am new in VBA)

Public Sub indata()
If (T4 = 1) Then
T3 = T2
Else
T3 = B2
End If
End Sub