Creating A Graph Using VBA??

I have implemented a function in VBA which calculates certain values, called 'IndexSim.' These values are not required to be outputted into the spreadsheet, however I would like to create a simple line graph plot of these values against 1,2,....etc however many values are chosen to be created. The code is as follows:

'Create storage for FTSE100 and binary payoff simulations.
Redim IndexSim(1 To SampleSz) As Double
Redim Payoff(1 To SampleSz) As Double

'Do the simulations.
For Cnt = 1 To SampleSz
IndexSim(Cnt) = gBmProcess(Kt, r, q, Vol, TMat - TNow)
If IndexSim(Cnt) >= IndexBetValue Then
Payoff(Cnt) = Range("D18").Value
Else
Payoff(Cnt) = Range("D19").Value
End If
Next Cnt

how I can create a line graph for the 'IndexSim' values, which will update everytime the macro button is clicked.